Hp Neoview Release 2.4 Software Manual de usuario descargar pdf (Pagina 114)

Table C-7 QUERY_RUNTIME_STATS_V1 Field Definitions (continued)

DescriptionData 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) NO DEFAULTQUERY_STATUS*

Whether the query is currently

running. Possible values are INIT,

WAITING, EXECUTING, HOLDING,

or SUSPENDED.

CHAR(10) NO DEFAULTQUERY_STATE*

Neoview segment name.CHAR(8) NO DEFAULTSEGMENT_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 DEFAULTREPOSITORY_QUERY_STATUS

ANSI Timestamp indicating when the

Workload Management Services

received the most recent runtime

statistics from the Query Executor.

TIMESTAMP(6) NO DEFAULTREFRESH_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 DEFAULTLAST_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 DEFAULTCOMPILE_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 DEFAULTCOMPILE_END_TS

114 Pre-R2.4 SP2 Query Statistics Views

1 2 ... 109 110 111 112 113 114 115 116 117 118 119 ... 127 128

Comentarios a estos manuales

Sin comentarios

Hp Neoview Release 2.4 Software Manual de usuario Pagina 114

Comentarios a estos manuales

Relacionado con productos y manuales para Software Hp Neoview Release 2.4 Software