Dave Beulke

The trail for the hunter of performance problems leads from the table to the indexes. As I went deeper into this performance jungle, I discovered more interesting artifacts.
DB2 Indexes
Since the table I talked about in the last post was typical of other tables in other applications in the company, it made a good candidate for [...]

Once you have reviewed the overall system for the aspects that we have discussed over the last few months, it’s time to drill down into your more critical transactions and processes. Critical transactions are those frequently executed transactions that are using excessive CPU or I/O resources. For this analysis using a performance monitor is necessary [...]

Last time we talked about excess tablespace scans, list prefetch and index scans. Let’s look further into potential application performance issues.
Lack of Data Access Reviews
Having good application and SQL review processes in place for testing, and quality assurance are vital for overall guarantees of application performance. One of the best ways to facilitate these application [...]

Happy New Year!
Be Proactive with your DB2 Performance
Is it?  Well, I know everyone is worried about the economy, but the best way to stay employed is to be proactive.  Proactive is not that difficult it is just being extra helpful and providing extraordinary service.
For example recently helping a client, I was asked to recommend a [...]