MX 2.x)

Starting, Configuring, and Managing MXCS

HP NonStop SQL/MX Connectivity Service Manual—524944-008

3-10

Resource Statistics

SQLPrepare

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

statement is received.

Table 3-4. Statement Statistics - SQLExecDirect

Statistic Value

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

the connection is established.

Message Attribute STATEMENT:SQLExecDirect (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 returned by the SQL compiler.

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

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

the execdirect started to the time the results are sent back.

ODBCExecutionTime Total MXCS SQL server CPU process time, in microseconds, from

the time the execdirect started to the time the results are sent back.

NumberOfRows

(ins/upd/del)

Number of rows that were inserted, updated, or deleted.

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.