(Willie Favero) I originally published this post last week (Avoiding a stage 2 predicate: index on expression – February 5). However, I didn’t care for the way some of it came out and a few people ask that I clarify a few things in that post. So, I am republishing that blog entry with a few minor ch

(Willie Favero) I was asked at a recent conference if IBM was serious about doing warehousing on System z. My standard answer is to look back at the history of DB2 for z/OS. You’ll see that there has always been a decision support influence. However, in DB2’s more recent releases, the changes and ad

(Henrik Loeser) Tomorrow is Valentine’s Day and there are different ways to collect important Brownie Points at your significant other. Today, I want to show you how you can do it as a DBA knowing your DB2 system catalog and some XQuery (mental note: DB2 was the right infrastructure decision, versio

(Dave Beulke) Getting back to one of the client’s main tables, we then researched the SQL that was being executed against it on a daily basis by analyzing the DB2 access methods. The DB2 access methods are captured at compile and bind time through the Explain process. Its output is available in the

(Paul Zikopoulos) Are you trying to ensure your licensing your IBM DB2 Version 9.5 for Linux, UNIX, and Windows (DB2 9.5) servers correctly in a high availability environment? Don’t have the time nor the will to read through the announcement letters, PLETs, or your licensing sheets? Author Paul Ziko

(Susan Visser) Check out the extensive library of on-demand demos on developerWorks. The demos cover everything from basics, like installation and setup, to advanced concepts for you veterans. In all, you’ll find more than 250 demos (25 of which were added recently).

(Craig Mullins) Although a DB2 performance monitor is probably the best solution for gathering information about your DB2 subsystems and databases, you can gain significant insight into “what is going on out there” using the simple DISPLAY command. The DISPLAY command can be used to return informati

(Rohit Sardesai, Manojkumar Pal, Pankuj Chachra and Suresh Das) Learn how you can leverage the features of WebSphere Business Services Fabric to build composite business applications that support dynamic binding and orchestration. In the final article in this 5-part series you’ll learn how to deploy

(Robert Catterall) A lot of people responsible for the management of DB2 for z/OS systems regularly look over DB2 monitor statistics reports or online displays to verify that all is well or to identify (and subsequently resolve) anything that is amiss. This is good. Some of these folks are a little

Renowned author and educator Bonnie Baker reveals the reasons behind some seemingly incongruous DB2 behavior, including the enigmatic SIX lock, the anomaly of index-only updates and deletes, and SORT syntax that actually improves performance. (R)