Previous Topic: SQL Statement Details

Next Topic: SQL Statement Overview (History)

Panel Elements

This section describes the elements on the panel.

Field Descriptions
Date

Date the information was collected.

System

Online region where the DBRM was used.

DBRM

DBRM name to which the information belongs

Action

Type of call that was issued with this statement

Stmt#

Number of the unique SQL statement that is contained in a Package or Plan.

Called

Number of times during the measurement session that this SQL statement was executed.

Total ACTV%

Percentage of the monitored period that CA Mainframe Application Tuner detected CPU utilization that was attributed to the processing of the SQL statements of this DBRM.

Total CPU sec

Amount of CPU time (in seconds) needed by DB2 to process DB2 calls for this SQL statement.

Total RESP sec

Total time (in seconds) for this SQL statement to complete processing.

CPU/Call

Amount of CPU time (in seconds) needed by DB2 to process each DB2 call for this SQL statement (Total CPU Sec / Total Called).

RESP/Call

Average response time (in seconds) for this SQL statement to complete processing (Total RESP Sec / Total Called).

SQL Statement Text

SQL statement text and corresponding SQL Declare text, if applicable.