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. |
This is a second-level detail line. This line shows one of five categories to which CPU time has been attributed:
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. |
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. |
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. |
[ Top of Page | Previous Page | Next Page | Contents | Index ]