Previous Topic: SQL Statement Overview (History)

Next Topic: Transactions that Use the DBRM

Panel Elements

This section describes the elements on the panel.

Line Commands
SD

Displays details about the SQL statement, including the SQL statement text, if available.

TX

Displays information about the transaction that is using the DBRM that contains the SQL statement

Field Descriptions
DBRM

Name of the DBRM that contains the SQL statement.

System

System name.

Action

Yype of call that was issued with this statement.

STMT#

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

Show recent months

Limits the display to the dates that occur in the specified time range.

The default value is 03 months. You can specify any value from 01 to 18 months.

Column Descriptions
Date

Date the measurement was done.

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.

CPU/Call

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

RESP/Call

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

Total RESP sec

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