HP Neoview Release 2.5 Software - Manual (Page 115)

Table E-5 QUERY_RUNTIME_STATS_V1_2400 Field Definitions (continued)
Description Data Type
Field Name (* means available only in
this view)
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
ANSI Timestamp indicating when the
Workload Management Services
received the most recent runtime
statistics from the Query Executor. TIMESTAMP(6) NO DEFAULT REFRESH_TS
Repository-generated ANSI
Timestamp showing when this row
was last updated. You can use this
value to monitor whether the query is
still running. TIMESTAMP(6) NO DEFAULT LAST_UPDATE_TS
ANSI Timestamp, in Local Civil Time,
indicating when query compilation
began. If this information is initially
unavailable, it is assigned the value
NULL and later updated with the
correct value. This field is updated
whenever the Repository updates the
statistics. TIMESTAMP(6) NO DEFAULT COMPILE_START_TS
Query Statistics for Pre-R2.4 SP1 115