HP Neoview Release 2.5 Software - Manual (Page 128)

Table E-8 QUERY_RUNTIME_STATS_V1 Field Definitions (continued)
Description Data Type
Field Name (* means available only in
this view)
Calculated number of elapsed
microseconds that the master executor
spent on behalf of the query since the
query began execution, computed as
query execution end time minus query
execution start time. If query execution
start time (EXEC_START_TS), end time
(EXEC_END_TS), or both are NULL,
this value is also NULL. INTERVAL SECOND(12,6) NO
DEFAULT MASTER_EXECUTOR_BUSY_TIME*
Calculated compile time in
microseconds, computed as
compilation end time minus
compilation start time. If compilation
start time (COMPILE_START_TS), end
time (COMPILE_END_TS), or both are
NULL, this value is also NULL; when
those values are updated, this value is
also updated. INTERVAL SECOND(12,6) NO
DEFAULT COMPILE_ELAPSED_TIME*
Cumulative node busy time in
microseconds for all disk processes
involved in the query. INTERVAL SECOND(12,6) NO
DEFAULT DISK_PROCESS_BUSY_TIME*
Time this process spent doing file
OPENs (in microseconds). INTERVAL SECOND(12,6) NO
DEFAULT OPEN_BUSY_TIME*
Time the Executor spent creating new
processes (in microseconds). INTERVAL SECOND(12,6) NO
DEFAULT PROCESS_CREATE_BUSY_TIME*
Elapsed clock time, in minutes, since
the query started executing, including
compile time and time spent in the
WMS queue. Sum of
MASTER_EXECUTOR_BUSY_TIME,
COMPILE_ELAPSED_TIME, and
QUE_TIME. INTERVAL MINUTE(18) NO
DEFAULT QUERY_ELAPSED_TIME
Unique session ID generated by the
NDCS SQL server at the time the
connection is established. CHAR(104) NO DEFAULT SESSION_ID
Unique identifier for this SQL
statement. Value returned by the
Neoview SQL compiler (PREPARE). CHAR(160) NO DEFAULT QUERY_ID
Unique statement ID generated by the
NDCS SQL server at the time the
PREPARE command is received. CHAR(110) NO DEFAULT STATEMENT_ID
Reserved for future use. CHAR(50) NO DEFAULT QUERY_NAME
Name of service registered with
Workload Management Services.
Corresponds to SERVICE_ID. CHAR(24) NO DEFAULT SERVICE_NAME
Name of the workstation that initiated
the query. CHAR(30) NO DEFAULT CLIENT_ID
Name of the application used to
connect to the database and send the
query, such as, ODBC, FASTJDBC. CHAR(16) NO DEFAULT APPLICATION_ID
128 Pre-R2.5 Query Statistics Views