Cancel a query from system offender – HP Neoview Release 2.5 Software User Manual
Page 207
Description
Field
Group Box
Total amount of processor (CPU) time used by the query in the previous
refresh interval. The display format is hh:mm:ss.sss for hours, minutes,
and seconds.
Last Interval Processor
The difference between the current and previous sample of the processor
(CPU) utilization, which is the Total Processor time minus the Last
Interval Processor time
Delta Processor
Amount of processor (CPU) cycles the query is consuming (rate of
processor usage), which is the Total CPU time divided by the Elapsed
time
Processor Usage/Sec
Number of opens (one per partition), which is the number of OPEN
calls performed by the Neoview SQL executor on behalf of the query
Opens
Other
Error code that triggered the Automatic Query Retry (AQR) for the
recent retry
Error Before AQR
Number of retries that occurred for this query until now
AQR Num Retries
Number of seconds that the SQL engine waited before it initiated an
AQR
Delay Before AQR
Either YES or NO, indicating whether the query's statistics are
aggregated
Aggr Query
Total number of queries in the aggregated query
Aggr Total Queries
Difference in seconds between the current time and the last time that
the aggregation was updated
Aggr Secs Since Last
Update
Difference in seconds between the current time and the first time that
aggregation was updated
Aggr Secs Total Time
Text of the SQL query
Query Text (Preview)
Length of the query text, including spaces
Length
Related Topics
“Cancel a Query From System Offender” (page 207)
“Cancel a Query From Metric Miner” (page 227)
“Cancel a Query From the SQL Whiteboard” (page 215)
Cancel a Query From System Offender
Only an administrator user can cancel a query. To cancel a query by using the System Offender:
1.
Display the Workload Detail dialog box as described in
“Get Query Workload Information”
2.
Click [ Cancel Query ]. A confirmation dialog box appears.
3.
Click [ Yes ] or [ No ].
NOTE:
You can also cancel a query from the SQL Whiteboard. See
.
Related Topics
“Get Query Workload Information” (page 201)
“Use the Workload Detail Dialog Box” (page 201)
Terms
Cancel a Query From System Offender
207