MX 3.x)

Starting, Configuring, and Managing MXCS

HP NonStop SQL/MX Connectivity Service Manual—640327-001

3-12

Resource Statistics

SQLPrepare

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

statement is received.

SQLFetch

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

closed.

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

execdirect was successful.

RowsAccessed Cumulative number of rows accessed.

RowsRetrieved Cumulative number of rows retrieved.

DiscReads Cumulative number of disk reads.

MsgsToDisc Number of messages sent to the disk process.

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

process.

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

LockEscalation Cumulative number of times record locks are escalated to file

locks.

Table 3-5. Statement Statistics - SQLPrepare

Statistic Value

Session ID Unique session ID generated by the MXCS SQL server at the time

the connection is established.

Message Attribute STATEMENT:SQLPrepare (Statistics option that was selected)

Sequence Number Message sequence number generated by MXCS. The number begins

with 0 (zero) and is incremented by 1 with each new record.

StatementID Unique statement ID generated by the MXCS SQL server at the time

the Prepare command is received.

EstimatedCost Estimated query cost.

StatementType Valid types are: Insert, Delete, Update, Select.

SQLCompileTime Total MXCS SQL server real time, in microseconds, from the time the

prepare starts to the time it returns to the client with the compile

results,

ErrorCode Prepare error code, if any. A zero (0) indicates that the prepare was

successful.

Table 3-4. Statement Statistics - SQLExecDirect

Statistic Value