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

Table E-6 ODBC_QUERY_STATS_V1 Field Definitions

DescriptionData TypeField Name

Segment number of the NDCS server

that reported the statistics.

INTEGER UNSIGNEDSEGMENT_ID

Processing node number of the NDCS

server which reported the statistics.

This is the node where the master

executor process which executed the

query was running.

INTEGER UNSIGNEDNODE_ID

ANSI SQL timestamp in Local Civil

Time when the statistics were

recorded in the Repository.

TIMESTAMP(6)QUERY_EVENT_DATETIME

ANSI SQL date in Local Civil Time

when the statistics were recorded in

the Repository.

DATEQUERY_EVENT_DATE

ANSI SQL time in Local Civil Time

when the statistics were recorded in

the Repository.

TIME(6)QUERY_EVENT_TIME

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) or

NCHAR(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

Query Statistics for Release 2.4 117

1 2 ... 112 113 114 115 116 117 118 119 120 121 122 ... 141 142

Commentaires sur ces manuels

Pas de commentaire

Hp Neoview Release 2.5 Software Manuel d'utilisateur Page 117

Commentaires sur ces manuels

Produits connexes et manuels pour Logiciel Hp Neoview Release 2.5 Software