Previous Topic: DBRM Overview

Next Topic: SQL Statements Exceeding Thresholds

Panel Elements

Field Descriptions
DBRM

Displays the name of the DBRM.

Show recent months

Displays the number of months entered (if the information is available for the period entered).

Column Descriptions
Date

Date the measurement was done.

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 all SQL statements of this DBRM.

Total RESP sec

Total time (in seconds) for all SQL statements of this DBRM to complete processing.

SQL#

Number of SQL statements running in this DBRM for which Performance Management Assistant has gathered consumption data from CA Mainframe Application Tuner.

Total Called

Total number of SQL statements that have been executed from this DBRM during the measurement period.

CPU/Call

Value of Total CPU sec column divided by the value of the SQL# column.

RESP/Call

Value of Total RESP sec column divided by the value of the SQL# column.