(Dave Beulke) While talking with clients and friends at the recent conferences, I noticed that everyone seemed to like the blog entries I’ve done about the performance features of DB2 v9 for z/OS. Some have even implemented some of the features previously mentioned and have already reduced their cos

(Julian Stuhler) Despite several key performance enhancements delivered in DB2 version 8, some new customers saw little or no overall improvement due to the overheads inherent in the move to 64-bit architecture and other architectural changes.

(Hebba Soliman and Ahmed Khairy) If you work with IBM Lotus Web Content Management, one of your recurring tasks is defining site structure. This task by its nature is time-consuming and repetitive; you are required to take more than 10 distinct steps to create a single site or site area. Moreover, s

(Radim Kolar) Yesterday, DB2 Express C 9.7.1 was released. I have one non root db2 9.7.0 copy floating around and wanted to update it. Non root db2 installations are very convenient for casual testing. They can be installed quickly by regular user and you do not need to seek assistance of unix admin

(Willie Favero) I’m working with Paul Bartak on a little something that will allow us to better understand how customers have configured DB2 subsystem parameters (DSNZPARMs). Paul came up with the idea that it would be great to know, with some certainty, how customers run DB2. Instead of getting a p

(Scott L. Forstie) This article explains how to collect an SQL Performance Monitor and understand how many of the SQL queries are using SQE and why other SQL statements continue to use CQE. SQE is the strategic query engine on DB2 for i, with better performance, scaling and tooling such as the SQL P

(Troy Coleman) During the process of tuning SQL statements, DBAs will use the EXPLAIN statement to determine the access path taken by DB2 to retrieve the data.

(Robert Catterall) One of the more interesting features delivered in recent years for DB2 for z/OS is the data-partitioned secondary index, or DPSI (pronounced “DIP-see”).

(Joe Lennon) Creating applications that use a hybrid of relational data and XML data is easy thanks to the pureXML feature of IBM DB2 database servers. In this tutorial, you use PHP to create a Web application that connects to an IBM DB2 Express-C database and stores some of its data in traditional

(Willie Favero) Part 3 of my little dissertation about RDS sort has arrived. This has been one very busy weekend publishing blog stuff that has sort in it. Today we talk about the buffer pools defined in support of sort.