|
|
|
This section describes the elements on the panel.
Displays the SQL statement text, if available.
Displays a historical overview of the selected SQL statement. SQL information is displayed for one SQL statement and one system ID for all available days.
Date the information was collected.
Online region where the DBRM was used
DBRM name to which the information belongs
Creation date of the DBRM
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 all SQL statements of this DBRM.
Total time (in seconds) for all SQL statements of this DBRM to complete processing.
Only SQL statement consumption data that exceeded this threshold value was gathered by Performance Management Assistant from CA Mainframe Application Tuner.
Type of call that was issued with this statement.
Number of the unique SQL statement that is contained in a Package or Plan.
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.
Total time (in seconds) for this SQL statement to complete processing.
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.
| Copyright © 2011 CA. All rights reserved. | Tell Technical Publications how we can improve this information |