This section describes the elements on the panel.
Displays details about the SQL statement, including the SQL statement text, if available.
Displays information about the transaction that is using the DBRM that contains the SQL statement
Name of the DBRM that contains the SQL statement.
System name.
Yype of call that was issued with this statement.
Number of the unique SQL statement that is contained in a Package or Plan.
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.
Date the measurement was done.
Number of times during the measurement session that this SQL statement was executed.
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.
Amount of CPU time (in seconds) needed by DB2 to process DB2 calls for this SQL statement.
Amount of CPU time (in seconds) needed by DB2 to process each DB2 call for this SQL statement.
Average response time (in seconds) for this SQL statement to complete processing.
Total time (in seconds) for this SQL statement to complete processing.
| Copyright © 2011 CA. All rights reserved. | Tell Technical Publications how we can improve this information |