Dave Beulke

Materialized Query Tables (MQTs) are really great for DB2 data warehousing situations and also for all types of reporting applications. Combining multiple MQTs is one technique that is good for providing all types of reporting capabilities and answers. By combining multiple MQTs, the DB2 SQL optimizer can sometimes automatically rewrite the queries from [...]

The beta of DB2 10 for z/OS continues to progress with the early indications that the relative performance processing bar is definitely being raised in this next version.  Early DB2 10 beta customers are truly experiencing 5-10% performance improvements out of the box.  Some are even experiencing greater improvements because their unique application processing fits [...]

It seems that I hit a nerve when I was talking about DB2 tools. It seems many shops are upset at the rising costs of third party tools. IBM’s responses of some free tools that have limited capabilities are also getting limited enthusiasm.
What has been interesting is there really seems to be support for [...]

Performance tuning is always different for every system and application.  In addition, the different DB2 LUW DBM configurations and z/OS zParms provide customizable options to improve your system and application performance mix.  These parameters are usually standard with the DB2 LUW AUTOCONFIGURE options. The DB2 z/OS standard settings from years of previous versions and suggestions [...]

The comments about Optimization Service Center (OSC) and the free Data Studio were great last week.  Sorry I could not reply because I am working with clients on their DB2 performance issues. I’m only able to look through the DB2-L Digest in the evenings.
I agree that IBM has a great free product in OSC and [...]

Analyzing SQL access performance is difficult without any tools. The Optimization Service Center (OSC) is a great tool and resource within DB2 V9 for z/OS.  This tool helps you with the cost of the SQL, Visual Explain of the access path and provides the ability to dump and then look through the Dynamic Statement Cache [...]