In enterprises that rely on their DB2 database applications, IT teams must locate, analyze, and control resource-hungry or poorly performing DB2 applications and SQL. These tasks help to optimize performance and minimize system resource consumption.
CA Chorus for DB2 Database Management lets you identify and address resource-intensive SQL, focusing your performance tuning efforts on the areas that need the most assistance. You can drill down to the level that you need, conserve resources, and perform detailed application performance analysis, without conducting inefficient and high-cost SQL performance traces.
CA Chorus for DB2 Database Management lets you view and act on current and historical DB2 accounting trace information from various application levels to understand the application workload and performance fully. This capability lets you determine the most frequently used plans, programs, and SQL statements without resource-intensive DB2 performance traces. You can use this information to view your top ten worst performing DB2 SQL statements, packages, and plans that are executing in your environment. Dynamic and static DB2 SQL statements are also monitored. This information lets you focus your tuning efforts where they are most needed.
Additional capabilities let you analyze SQL activity and view and understand SQL error activity.
You can use DB2's ability to collect statistics in real time to help monitor the activity against your packaged application objects. Real-time statistics lets DB2 collect statistics on table spaces and index spaces and periodically write this information to two user-defined tables. Beginning with DB2 9, these tables are an integral part of the system catalog. User-written queries and programs, or a DB2-supplied stored procedure, or Control Center, can use the statistics to make decisions for object maintenance.
You can analyze DB2 performance from the application folders in the Investigator. The Investigator provides actions that help you drill down further into application performance activity. The actions let you view application performance activity at various levels to perform the following functions:
This information helps you analyze real-time performance to identify and address applications and SQL statements causing poor performance. It can also help you reduce the SQL impact on DB2 and optimize overall DB2 performance, and identify the most frequently used plans, packages, and SQL statements.
|
Copyright © 2015 CA Technologies.
All rights reserved.
|
|