MX Release 3.2.1 (H06.26+, J06.15+)

ManualsBrandsHP ManualsServerHP Integrity NonStop J-Series

Table 4 Statement Statistics - SQLExecDirect

ValueStatistic

Unique session ID generated by the MXCS SQL server at

the time the connection is established.

Session ID

STATEMENT:SQLExecDirect (Statistics option that was

selected)

Message Attribute

Message sequence number generated by MXCS. The

number begins with 0 (zero) and is incremented by 1 with

each new record.

Sequence Number

Unique statement ID generated by the MXCS SQL server

at the time the Prepare command is received.

StatementID

Estimated query cost returned by the SQL compiler.EstimatedCost

Valid types are: Insert, Delete, Update, SelectStatementType

Total MXCS SQL server real time, in microseconds, from

the time the execdirect started to the time the results are

sent back.

ODBCElapsedTime

Total MXCS SQL server CPU process time, in microseconds,

from the time the execdirect started to the time the results

are sent back.

ODBCExecutionTime

Number of rows that were inserted, updated, or deleted.NumberOfRows (ins/upd/del)

Execdirect error code, if any. A 0 (zero) indicates that the

execdirect was successful.

ErrorCode

Cumulative number of rows accessed.RowsAccessed

Cumulative number of rows retrieved.RowsRetrieved

Cumulative number of disk reads.DiscReads

Number of messages sent to the disk process.MsgsToDisc

Size, in bytes, of the total number of messages sent to the

disk process.

MsgsBytesToDisc

Number of lock waits (this is the concurrency cost).LockWaits

Cumulative number of times record locks are escalated to

file locks.

LockEscalation

SQLPrepare

SQLPrepare statistics are written to the alternate EMS collector at the time a Prepare statement is

received.

Table 5 Statement Statistics - SQLPrepare