Application Performance Analyzer for z/OS, Version 11.1, User's Guide

Detail line descriptions

DB2 Plan detail line

This is the first-level detail line. Each line shows information about a DB2® Plan for which stored procedure measurement data was recorded.

Under Heading This is Displayed
Seqno A sequence number assigned to the DB2 plan.
Description The plan name.
Percent of Time The percentage of the measurement interval duration stored procedure requests under the indicated DB2 Plan were being processed.

Category detail line

This is a second-level detail line. This line shows one of five categories to which CPU time has been attributed:

APPLCN
Application Code
SYSTEM
System/OS Services
DB2SQL
SQL Processing
DATAMG
Data Management (DASD) Requests
NOSYMB
No Module Name Found, any execution measured at locations for which no load module name could be determined is attributed to this category.

As F14 is used for analyzing CPU consumption in DB2 Store Procedures, the category DB2SQL is the one where you should see the majority of the activity. This category and the detail lines under it are described here. For detailed information on the other categories, see C01 - CPU usage by category.

Under Heading This is Displayed
Seqno The category name "DB2SQL."
Description The category description "SQL Processing."
Percent of Time The percentage of the measurement interval duration SQL requests under the indicated DB2 Plan were being processed.

DB2 DBRM detail line

This is a third-level detail line shown directly under the DB2 Plan detail line. It quantifies the percentage CPU time for a specific SQL request.

Under Heading This is Displayed
Seqno A sequence number assigned, by Application Performance Analyzer, to the SQL statement.
Description The DBRM name, DBRM statement number and SQL function.
Percent of Time The percentage of the measurement interval duration the indicated SQL Request was being processed.

DB2 load module detail line

This is a fourth-level detail line showing activity for DB2 load modules used in the SQL request processing.

Under Heading This is Displayed
Seqno The DB2 Load Module name.
Description If a DPA functional description is found for the module name, it is reported under this heading.
Percent of Time The percentage of the measurement interval duration the indicated SQL Request being processed was in this module.



Rate this page

[ Top of Page | Previous Page | Next Page | Contents | Index ]