Using the Central Component › Measurement Lists › DB2 Plan/DBRM Overview › Column Descriptions

Column Descriptions

DBRM

Displays the name of a package (DBRM) that describes the SQL statement.

STMT NUM

Displays the statement number for a specific statement contained in a package or plan.

TYPE

Displays the type of call issued with this statement as an argument.

CA Mainframe Application Tuner displays ???????? when the DB2 control block is not yet valid. Valid values for call type are OPEN, FETCH, CLOSE, PREPARE, SELECT, INSERT, DELETE, UPDATE and DYNAMIC.

TOTAL COUNT

Displays the number of times during the monitoring session that CA Mainframe Application Tuner detected this SQL statement executing.

CPU-P-CALL

Displays the average CPU time (in seconds) that was needed by DB2 to process DB2 calls for this SQL statement (TOTAL CPU / TOTAL CALLED).

TOTAL CPU

Displays the amount of CPU time (in seconds) that was needed by DB2 to process DB2 calls for this SQL statement.

AVERAGE RESP TIME

Displays the average response time (in seconds) for this SQL statement to complete processing (TOTAL RESP TIME / TOTAL CALLED).

TOTAL RESP TIME

Displays the total response time (in seconds) for this SQL statement to complete processing of all executions.