Dave Beulke

Integrated Data Management is the theme of the Information on Demand (IOD) IBM Conference where the tagline of “Innovate, Optimize and Perform” is everywhere. Since I have been designing and implementing integrated high performance databases using DB2 for z/OS since Version 1.2 and DB2 Linux UNIX and Windows systems since it was called OS/2 Extended Edition, [...]

We’ve talked about CICS transaction performance improvements and security performance improvements. Now let’s check into the Sort Work, EDM, RID and Buffer Pools.
DB2 Sort Work Pool
The DB2 system work area consists of a number of DB2 DSNDB07 work tablespace data sets to handle the DB2 SQL sort requirements. The DB2 sort work pool data sets [...]

Over the last two posts, I gave you an overview of a DB2 system that needed performance improvements. Here we are going to delve deeper into the problems and recommendations.

System Discoveries and Recommendations
The operating system, CICS and DB2 systems were operating efficiently and managed well within the overall environment. As the number of transactions [...]

In this post, I’ll delve a little deeper into the system architecture and CPU reduction opportunities found in a major DB2 system at a large financial institution.

Analysis
In order to do a complete performance analysis of the system, the statistics were reviewed using the standard DB2 performance reports. This data provided a basis of [...]

Every client is different and working in a variety of different environments helps me understand different systems, applications and database design performance aspects and what works and doesn’t work. Over the next few weeks, I’ll be highlighting for you how to improve the performance of a major DB2 systems, applications and databases and using my [...]