Extreme Performance Tuning for DB2 LUW

Harness the Full Performance Potential of DB2 LUW with DBI's DB2 performance tuning solution. See health of all databases on one screen, and drill for fast diagnosis.

Capture, Analyze and Optimize - DB2 z/OS Workload Tuning with EZ-DB2

Every DBA knows how frustrating it is to fix a DB2 performance issue – just to have another emerge in its place. Dealing with impact of change, either proactively or reactively, is a big time drain for most DBAs. With EZ-DB2, we’ll show you how simple it is to test your tuning ideas in an environment that predicts the impact of any change on the entire workload in minutes rather than days.

Workload Centric Index Optimization with EZ-DB2

Index tuning is one of the most powerful tools available to improve application and system performance. Indeed, where packaged software or dynamic SQL is concerned, it may be the only option. However, due to lack of DBA resources, Index Tuning is often approached in a “fire-fighting” mode, whereby indexes are designed to meet the needs of particular problematic SQL without regard to the overall effect on the workload. To design the perfect set of indexes for an entire workload, taking into account execution frequency and index maintenance costs is not a trivial task. Indeed, It would be virtually impossible to meet this challenge without an automated tool. This presentation describes the EZ-DB2 index design tools, including EZ-Index Analyzer and EZ-XOP, which uses a unique patented process that actually takes advantage of the DB2 Optimizer to derive the optimal index configuration for an SQL workload.