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

ManualsBrandsHP ManualsServerHP Integrity NonStop J-Series

Table 2 Statement Statistics - SQL Statement (continued)

ValueStatistic

Unique statement ID generated by the MXCS SQL server

at the time the Prepare command is received.

StatementID

Text of the SQL statement. This field can be distributed in

multiple messages.

SQL Text

SQLExecute

SQLExecute statistics are written to the alternate EMS collector at the time an Execute statement is

received.

Table 3 Statement Statistics - SQLExecute

ValueStatistic

Unique session ID generated by the MXCS SQL server at

the time the connection is established.

Session ID

STATEMENT:SQLExecute (the 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

Total MXCS SQL server real time, in microseconds, from

the time the execute started to the time the results are sent

back.

ODBCElapsedTime

Total MXCS SQL server CPU process time, in microseconds,

from the time the execute started to the time the response

is sent back to the client with the results error code.

ODBCExecutionTime

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

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

execute 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

Input parameter value.SQLValues

SQLExecDirect

SQLExecDirect statistics are written to the alternate EMS collector at the time an Execute statement

is received.

Resource Statistics 33