HP Neoview Release 2.3 Software - Manual (Page 33)

Table 3-4 QUERY_RUNTIME_STATS_V1 Field Definitions (continued)
Description Data Type
Field Name (* means available only in
this view)
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). 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(32) or NCHAR(32) NO
DEFAULT 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
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) or NCHAR(21) NO
DEFAULT STATEMENT_TYPE
The operating system process name of
the Master Executor. CHAR(18) or NCHAR(18) NO
DEFAULT PROCESS_NAME
Neoview user role name. CHAR(18) or NCHAR(18) NO
DEFAULT ROLE_NAME
Query Statistics 33