(Lockwood Lyon) Database administrators tend to think of SQL tuning as necessary, important, even critical. The reality is that the savings realized by tuning SQL, usually manifested in saved CPU time and decreases in elapsed times, may offset the costs incurred in time and resources.

(Ember Crooks) You’ve got your database code page set as UTF-8, what more do you need to know, right? DB2 automatically handles all that conversion stuff for you, right?

(Yan Yan Liu and Xiao Feng Wang) IBM Database Patterns provides solutions to easily provision and manage databases on IBM Workload Deployer (IWD) in a private cloud. IWD is a cloud management appliance that delivers a patterns-based approach to deploy and manage application environments in the cloud

(Dave Beulke) The International DB2 User Group (IDUG) North American conference is only a month away. This year IDUG is really going to be great because many DB2 related items are coming together and are sure to be detailed, dissected and discussed in depth at the conference.

(Robert Catterall) In part one of this two-part blog entry, I pointed out that the notion that one cannot control a DB2 for z/OS client-server workload as one can a local-to-DB2 application is quite outdated, and I described a couple of the mechanisms (native SQL procedures, and roles and trusted co

(Feng Li, Jin Shang and Jia Tang) In this article, you’ll learn how IBM Business Process Manager uses WebSphere Adapters to connect to external systems, and how data flows between external systems and the human tasks of IBM BPM. Using these capabilities, you’ll see how you can integrate your BPM app

(Troy Coleman) Businesses as well as consumers demand that more information be placed at their fingertips. When using mobile devices such as iPhone and Android, people expect answers to their questions in seconds rather than minutes. This reality is driving the emergence of in-memory database (IMDB)

(Jack Vamvas) The DB2 message SQL20169W The buffer pool is not started appeared in response to a ALTER BUFFERPOOL statement

(Willie Favero) “Red Alerts” are serious and should be address in as timely manner as possible.

(Dino Quintero, Ricardo Dobelin Barros, Ashraf Gomaa, Jose Higino, Archana Kumar, Majid Ouassir, Adam Parker and Joanna Wong) This IBM RedPaper describes the integration of IBM Platform Symphony 5.2 and IBM InfoSphere BigInsights 1.4 in an IBM System x cluster.