(Stephane Journot) You have a nice DB2 CLP prompt, looks like “db2>”, but you want more, you want a efficient prompt. It is possible with DB2 to add or modify your CLP ! DB2 have a registry variable named DB2_CLPPROMPT which allows us to define the prompt to be used in the CLP interactive mode.

(Timothy Prickett Morgan) Last week was a big week for operating systems. Microsoft delivered Windows 7 for desktops and started shipping Windows Server 2008 R2 for servers. And IBM, as The Four Hundred reports about elsewhere in this issue, put out a dot release of its current i 6.1 platform, which

(Bonnie Baker) Long ago, a learned colleague (Prem Mehra) introduced me to the concept of unnecessary SQL and his oft-quoted truism: “There is no better-performing SQL than the SQL that is not executed.” In this three-part series, we are going to look at SQL that is totally unnecessary and should be

(Shalom Momi Sabag) Well, I know I still owe some answers regarding load resume yes shrlevel change post, but this post will be about an issue I faced when conducting the load utility testing.

(David Beulke) IBM DB2 9 for z/OS is loaded with features that can boost the performance of your applications. In this column, I’ll tell you about two that really stand out, but check out the online version of the column for a table of the top 50. Implementing any of these features can help reduce y

(Craig S. Mullins) Although robust performance and administration tools are probably the best solution for gathering information about your DB2 subsystems and databases, you can gain significant insight into your DB2 environment simply by using the DISPLAY command. There are multiple variations of t

(Robert Catterall) Greetings from Las Vegas. Day one of IBM’s 2009 Information on Demand conference was a good one. In this post I’ll share with you some of the more interesting items of information I picked up in today’s sessions. I’ll post at the end of days 2, 3, and 4, as well.

(Willie Favero) Shocker… part 3 of my series on stored procedures is finally getting posted. This is a follow-on to my post on NUMTCB. For completeness, I wanted to review the other NUMTCB settings for the languages and situations we haven’t discussed.

(Jack Baker and John Rollins) When it comes to predictive analytics and business intelligence (BI), organizations with large information warehouses usually face a choice: create and implement data mining models directly within the database environment, or create them in a separate analytic environme

(Willie Favero) This one fixes a couple of problems with asymmetric index page split. It seems there could be an occasional issue and a possible inefficiency with page splitting in DB2 9. APAR PK62214 takes care of those issues.