HP Neoview Release 2.4 Software - Manual (Page 99)

Table C-4 QUERY_RUNTIME_STATS_V1_2400 Field Definitions (continued)
Description Data Type
Field Name (* means available only in
this view)
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
Neoview user role name. CHAR(18) NO DEFAULT ROLE_NAME
What the executor is doing (INITIAL,
OPEN, EOF, CLOSE, DEALLOCATED,
FETCH, CLOSE_TABLES, PREPARE,
PROCESS_ENDED, UNKNOWN). For
queries with actual end statistics, this
value will be CLOSE or
DEALLOCATED. For queries in
progress, or for which the Repository
did not receive actual end statistics,
this value will be any other value from
this list. CHAR(14) NO DEFAULT QUERY_STATUS*
Whether the query is currently
running. Possible values are INIT,
WAITING, EXECUTING, HOLDING,
or SUSPENDED. CHAR(10) NO DEFAULT QUERY_STATE*
Neoview segment name. CHAR(8) NO DEFAULT SEGMENT_NAME
Dashboard-supplied value for the
query status when completion statistics
are not available from WMS. This is
the field that shows whether the query
has completed. Possible values are
“Initial,” “Running,” “In queue,” and
“Completed.” When statistics are
received from WMS and
EXEC_END_TS is not empty, this field
is set to “Completed.” When the final
statistics are not received from WMS,
this field is set to “Assumed
Completed,” and EXEC_END_TS is
set to the time when the last request
for statistics was made. CHAR(20) NO DEFAULT REPOSITORY_QUERY_STATUS
VIEW NEO.HP_METRICS.QUERY_RUNTIME_STATS_V1_2400 99