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

Table C-5 ODBC_QUERY_STATS_V1 Field Definitions (continued)

DescriptionData TypeField Name

Message sequence number generated

by NDCS. Numbering starts at 0 and

is incremented by 1 for each new

record.

SMALLINT UNSIGNEDSEQUENCE_NUM

Repository assigned value. Used

internally.

INTEGER UNSIGNEDMETRIC_CLASS_ID

Repository assigned value. Used

internally.

INTEGER UNSIGNEDMETRIC_CLASS_VERSION

Number of rows required to

accommodate the query text, which

is provided in 3200–byte chunks.

SMALLINT UNSIGNEDSEQUENCE_SIZE

Estimated query cost.DOUBLE PRECISIONEST_COST

Cumulative number of disk reads.LARGEINTDISK_READS

Cumulative number of times record

locks were escalated to file locks.

LARGEINTLOCK_ESCALATIONS

Number of times the statement

waited for a lock request

(concurrency cost).

LARGEINTLOCK_WAITS

Size, in bytes, of the total number of

messages sent to the Encapsulated

SQL Access Manager (ESAM).

LARGEINTMESSAGE_BYTES_TO_DISK

Number of messages sent to ESAM.LARGEINTMESSAGES_TO_DISK

Cumulative number of rows accessed.LARGEINTROWS_ACCESSED

Cumulative number of rows

retrieved.

LARGEINTROWS_RETRIEVED

Number of rows inserted, updated,

deleted.

LARGEINTNUM_ROWS_IUD

Total NDCS server real time, in

microseconds, from the time the

execute or execdirect started to the

time the results were sent back.

LARGEINTQUERY_ELAPSED_TIME

Node processing time.LARGEINTMASTER_EXECUTION_TIME

Total number of executes performed

on this statement.

LARGEINTTOTAL_EXECUTES

Process identification number of the

NDCS server.

INTEGER UNSIGNEDPIN

START if this record contains

information collected at the start of

the query, or END if it contains

statistics collected at the end of the

query.

CANCELLED for queries killed

through Neoview Query Viewer.

CHARACTER(5)STATEMENT_STATUS

Execution priority of the NDCS

process at the time the connection

request is received.

SMALLINT UNSIGNEDSTART_PRIORITY

Prepare error code. A value of 0

indicates that the prepare was

successful.

CHARACTER(6)ERROR_CODE

102 Pre-R2.4 SP2 Query Statistics Views

1 2 ... 97 98 99 100 101 102 103 104 105 106 107 ... 127 128

Comentarios a estos manuales

Sin comentarios

Hp Neoview Release 2.4 Software Manual de usuario Pagina 102

Comentarios a estos manuales

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