Hp Neoview Release 2.4 Software Manuel d'utilisateur télécharger pdf (Page 99)

Table C-4 QUERY_RUNTIME_STATS_V1_2400 Field Definitions (continued)

DescriptionData 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 DEFAULTSTATEMENT_TYPE

The operating system process name of

the Master Executor.

CHAR(18) NO DEFAULTPROCESS_NAME

Neoview user role name.CHAR(18) NO DEFAULTROLE_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 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

VIEW NEO.HP_METRICS.QUERY_RUNTIME_STATS_V1_2400 99

1 2 ... 94 95 96 97 98 99 100 101 102 103 104 ... 127 128

Commentaires sur ces manuels

Pas de commentaire

Hp Neoview Release 2.4 Software Manuel d'utilisateur Page 99

Commentaires sur ces manuels

Produits connexes et manuels pour Logiciel Hp Neoview Release 2.4 Software