Dave Beulke

Avoid Inappropriate Tablespace Scans
There are many DB2 access paths available. The most expensive of these is a tablespace scan because it causes DB2 to scan all the entries of a table to retrieve the rows desired by the application.  Within most of the system and application performance reviews done at one recent client’s review, there [...]

Last time we looked at the application design of a major DB2 system. Now, let’s delve a little further and look at the SQL used in these applications.
Taking Advantage of Relational Technology
During reviews of various client systems, analyzing the SQL used is very helpful for understanding how sophisticated the shop and system are at leveraging [...]