HP Neoview Release 2.3 Software User Manual

Page 34

Table 3-4 QUERY_RUNTIME_STATS_V1 Field Definitions (continued)

Description

Data Type

Field Name (* means available only in
this view)

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) or NCHAR(14) NO
DEFAULT

QUERY_STATUS*

Whether the query is currently
running. Possible values are INIT,
WAITING, EXECUTING, HOLDING,
or SUSPENDED.

CHAR(10) or NCHAR(10) NO
DEFAULT

QUERY_STATE*

Neoview segment name.

CHAR(8) or NCHAR(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) or NCHAR(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

ANSI Timestamp, in Local Civil Time,
indicating when query compilation
ended. 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_END_TS

Repository Views