HP Neoview Release 2.5 Software - Manual (Page 205)

Runtime Statistics
Description Field Group Box
Type of SQL statement Statement Type Info
Statement identifier of the query, which is part of the query ID Statement ID
Execution state of the query Exec State
Top-level error code returned by the query, indicating whether the
query completed successfully or with warnings or errors. A positive
number indicates a warning. A negative number indicates an error. SQL Code
Internal error code returned to the statistics collector from the runtime
statistics (RMS) infrastructure Stats Code
Number of lock waits. This counter indicates the number of times the
query had to wait on a conflicting lock. A value of 0 indicates that no
locks were encountered while the query was executing. Lock Waits
Number of lock escalations. This counter indicates the number of times
row locks escalated into a file lock during the execution of the query.
A value of 0 indicates that no locks were escalated while the query was
executing. Lock Escalations
Number of rows inserted, updated, or deleted Num Rows IUD
Identifier of the parent query. If there is no parent query ID associated
with the query, NONE is displayed. Parent QID
Process priority of the master executor process Priority
Identifier of the transaction under which the query is executed. When
there is no transaction, the transaction ID is -1. Transaction ID
Number of SQL processes (excluding ESAM processes) involved in
executing the query Num SQL Processes
Number of Executor Server Processes (ESPs) created Processes Created
Time when the query compilation started (or when PREPARE started
for the query). The display format is yyyy-mm-dd (for year, month, and
day) and hh:mm:ss.sss (for hours, minutes, and seconds). Comp Start Time
Time when the query compilation ended (or when PREPARE ended
for the query). The display format is yyyy-mm-dd (for year, month, and
day) and hh:mm:ss.sss (for hours, minutes, and seconds). Comp End
Time when the query started executing. The display format is
yyyy
-mm-dd (for year, month, and day) and hh:mm:ss.sss (for hours,
minutes, and seconds).
Exec Start
Time when the query finished executing. While the query is still
executing, this field displays -1. When the query finishes executing, the
display format is yyyy-mm-dd (for year, month, and day) and
hh
:mm:ss.sss (for hours, minutes, and seconds).
Exec End
Amount of time that the query ran or is running. For running queries,
this is the time since the start of the query execution until the current
time. For completed queries, this is the difference between the Exec Start
and Exec End times. The display format is hhh:mm:ss for hours, minutes,
and seconds. Elapsed
Amount of time the query waited before it started executing (that is,
the time from entry into the system to the time when the query actually
starts to execute). The display format is hhh:mm:ss for hours, minutes,
and seconds. Wait
Amount of time the query was in the holding or suspended state. The
display format is hhh:mm:ss for hours, minutes, and seconds. Hold
Use the Workload Detail Dialog Box 205