HP Neoview Release 2.4 Software - Manual (Page 98)

Table C-4 QUERY_RUNTIME_STATS_V1_2400 Field Definitions (continued)
Description Data Type
Field Name (* means available only in
this view)
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
User alias, or Neoview GROUP.USER
form if no alias exists. CHAR(128) USER_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
98 Pre-R2.4 SP2 Query Statistics Views