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 under which SQL request measurement data was recorded.

Under Heading This is Displayed
Seqno A sequence number assigned, by Application Performance Analyzer, to the DB2 plan.
Plan/Pgm The DB2 Plan name.
Nbr of Calls The number of SQL calls counted for this DB2 Plan.
CPU Time: Total The total CPU time for all SQL calls counted for this statement. Large numbers will be expressed in minutes with an M suffix.
CPU Time: Mean The mean CPU time per SQL call. Large numbers will be expressed in minutes with an M suffix.
CPU time: Pct The percent of total CPU time this plan used.
Svc Time: Total The total service time for all SQL calls for this statement. Large numbers will be expressed in minutes with an M suffix.
Svc Time: Mean The mean service time per SQL call. Large numbers will be expressed in minutes with an M suffix.
SVC time: Pct The percent of total service time this plan used.

SQL request detail line

This is the second-level detail line shown directly under the DB2 Plan detail line. It quantifies an individual SQL statement.

Under Heading This is Displayed
Seqno A sequence number. This is assigned by Application Performance Analyzer to uniquely identify the SQL request. Either "S" or "D" precedes the sequence number indicating if the SQL statement is static or dynamic.
Plan/Pgm The DBRM name.
Stmt# The precompiler statement number of the SQL statement.When the statement number is zero, it indicates that the SQL statement was not produced by the DB2 precompiler or the SQL preprocessor, but was generated by some other means. For example, JDBC SQL statements have statement numbers that are zero.
SQL Function The SQL function.
Nbr of Calls The number of SQL calls counted for this statement.
CPU Time: Total The total CPU time for all SQL calls counted for this statement. Large numbers will be expressed in minutes with an M suffix.
CPU Time: Mean The mean CPU time per SQL call. Large numbers will be expressed in minutes with an M suffix.
CPU time: Pct The percent of total CPU time this statement used.
Svc Time: Total The total service time for all SQL calls for this statement. Large numbers will be expressed in minutes with an M suffix.
Svc Time: Mean The mean service time per SQL call. Large numbers will be expressed in minutes with an M suffix.
SVC time: Pct The percent of total service time this statement used.

SQL statement text detail line

This is third-level detail line shown directly under the SQL request detail line. It shows the SQL statement text. If necessary, more than one line is displayed in order to show the full SQL text.




Rate this page

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