HP Neoview Release 2.4 Software User Manual
Page 35
Table 3-4 QUERY_RUNTIME_STATS_V1 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) or NCHAR(104) NO
DEFAULT
SESSION_ID
Unique identifier for this SQL
statement. Value returned by the
Neoview SQL compiler (PREPARE).
See
“Format of the Query ID Field”
CHAR(160) or NCHAR(160) NO
DEFAULT
QUERY_ID
Unique statement ID generated by the
NDCS SQL server at the time the
PREPARE command is received.
CHAR(110) or NCHAR(110) NO
DEFAULT
STATEMENT_ID
Reserved for future use.
CHAR(50) or NCHAR(50) NO
DEFAULT
QUERY_NAME
Name of service registered with
Workload Management Services.
Corresponds to SERVICE_ID.
CHAR(24) or NCHAR(24) NO
DEFAULT
SERVICE_NAME
User alias, or Neoview GROUP.USER
form if no alias exists.
CHAR(20) or NCHAR(20)
USER_NAME
Name of the workstation that initiated
the query.
CHAR(30) or NCHAR(30) NO
DEFAULT
CLIENT_ID
Name of the application used to
connect to the database and send the
query; e.g., ODBC, FASTJDBC.
CHAR(16) or NCHAR(16) NO
DEFAULT
APPLICATION_ID
Query Statistics
35