HP Neoview Release 2.5 Software - Manual (Page 114)

Table E-5 QUERY_RUNTIME_STATS_V1_2400 Field Definitions (continued)
Description Data Type
Field Name (* means available only in
this view)
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
The SQL statement as returned by the
Neoview SQL compiler, one of
SELECT_UNIQUE,
SELECT_NON_UNIQUE,
INSERT_UNIQUE,
INSERT_NON_UNIQUE,
UPDATE_UNIQUE,
UPDATE_NON_UNIQUE,
DELETE_UNIQUE,
DELETE_NON_UNIQUE, CONTROL,
SET_TRANSACTION,
SET_CATALOG, SET_SCHEMA,
CALL_NO_RESULT_SETS,
CALL_WITH_RESULT_SETS,
SP_RESULT_SET, OTHER,
UNKNOWN. Unique queries involve
a search on a unique key. Note that
WMS does not monitor all types of
queries; the values in this field depend
on the types of queries WMS monitors. CHAR(21) NO DEFAULT STATEMENT_TYPE
The operating system process name of
the Master Executor. CHAR(18) NO DEFAULT PROCESS_NAME
114 Pre-R2.5 Query Statistics Views