Dave Beulke

Last time I wrote about some of the application performance aspects. This week we’ll delve deeper into DB2 Checkpoint aspects for recoveries and index definitions over your busiest tables and their potential performance impact.
DB2 Checkpoint System Frequency
The DB2 system runs transactions and takes system wide recovery checkpoints for system consistency and integrity. These [...]

We’ve checked out numerous areas to check for performance. Now its time to see how the application performance is doing within the DB2 system. During this post, I’ll talk about some of the other standard places to check for performance improvements.
Locking Tables and Lock Escalations
Looking into the DB2 system and application monitor showed huge spikes [...]

Last time I wrote about DB2 Checkpoint and index definitions over your busiest tables.  This week I will discuss the old style of tablespace definitions and their potential performance impact.
Tablespaces Need to Be Reorganized
The first thing to look at is the current state of the database tables and indexes.  Usually I find that there are [...]

We’ve checked into the Sort Work, EDM, RID and Buffer Pools. During this post, I’ll talk about some of the other standard places to check for performance improvements.
DB2 System Maintenance
The DB2 system software maintenance from IBM contains many fixes and performance adjustments in its software maintenance stream. When investigating this company’s maintenance levels, I discovered [...]