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

Table C-2 ODBC_QUERY_STATS_V1_2400 Field Definitions (continued)

DescriptionData TypeField Name

ANSI SQL timestamp in Coordinated

Universal Time when the statistics

were recorded in the Repository.

TIMESTAMP(6)QUERY_EVENT_DATETIME_UTC

ANSI SQL date in Coordinated

Universal Time when the statistics

were recorded in the Repository.

DATEQUERY_EVENT_DATE_UTC

ANSI SQL time in Coordinated

Universal Time when the statistics

were recorded in the Repository.

TIME(6)QUERY_EVENT_TIME_UTC

Unique session ID generated by the

NDCS server when the ODBC/JDBC

connection was established.

CHARACTER(108)SESSION_ID

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

VIEW NEO.HP_METRICS.ODBC_QUERY_STATS_V1_2400 87

1 2 ... 82 83 84 85 86 87 88 89 90 91 92 ... 127 128

Comentarios a estos manuales

Sin comentarios

Hp Neoview Release 2.4 Software Manual de usuario Pagina 87

Comentarios a estos manuales

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