Viewing DB2 Object Performance Data in the Investigator › Application Performance Monitoring › View by Keys

View by Keys

You can view application activity from the perspective of optional additional view by keys as follows:

• The DB2 connection user ID (AUTHID)
• The correlation ID, such as the batch job name or the CICS transaction name
• The DB2 connection type, such as TSO or CICS.
• The connection name, such as the CICS region name.
• The remote location name or IP address.
• The end user ID specified for distributed and RRSAF connections.
• The end user transaction and workstation ID specified for distributed and Resource Recovery Services Attachment Facility (RRSAF) connections.

You can display the column data by totals or averages.

Note: You must have enabled Additional View By Keys on the CA Detector collection start and specified a collection profile.

Important! Enabling additional keys collection activity can result in a significant increase in main storage requirements for active collections and DASD requirements for historical data. For more information about limiting the impact of this support, see the CA Detector User Guide.

You can select a key and can view all plans and packages that the key executed during the collection interval. You can also view exception SQL and SQL error collection data for the key.

Use the provided actions for further investigation and to view historical data for the selected key types in the Performance Warehouse.