As DB2 applications increase in complexity and the DB2 databases grow in size, helping ensure that performance becomes increasingly critical. When transactions use dynamic SQL that enters DB2 through various gateways or JDBC connections, it is crucial that your DB2 subsystems and applications are performing at their best.
The CA Chorus for DB2 Database Management discipline provides real-time performance monitoring of DB2 applications and subsystems, enabling database administrators (DBAs) to detect and correct performance problems rapidly. This discipline collects data from the z/OS subsystem interface, DB2 and z/OS control blocks, and DB2 performance traces to provide online access to critical performance statistics. In addition, you can monitor subsystems and application statistics to assess and troubleshoot problems as they arise. This functionality helps DBAs identify performance problems as they occur, fix critical issues before they impact service levels, and track performance trends for proactive performance management.
You can monitor current and historical DB2 subsystem performance data from the Investigator:
Note: Only database, table space and index space, and table activity can be viewed from data sharing groups.
The Investigator provides actions that help you drill down further into subsystem performance activity. The actions let you view subsystem activity at various levels to help reduce the time and effort involved in identifying and correcting DB2 performance problems.
|
Copyright © 2015 CA Technologies.
All rights reserved.
|
|