DB2 System Performance Metrics Re-Visited
Joel Goldstein
Responsive Systems
E-mail joel_goldstein@compuserve.com
Web Site: www.responsivesystems.com
Abstract:
DB2 is a complex database management system, that has a major impact upon your overall processing environment. Installations are constantly looking for ways to measure, analyze, and control its resource consumption. This presentation assumes that the reader has a basic understanding of DB2, and does not define basic DB2 terminology. It addresses the origins and data available for analyzing, tuning, and tracking the performance of the DB2 System, and inter-dependencies and relationships between the various data elements. Many of the system tuning options are explained and trade-offs discussed, since the systems and applications are always somewhat different for each corporation.