SQL/MX Connectivity Service Manual for SQL/MX Release 3.2 (H06.25+, J06.14+)

Table 5 Statement Statistics - SQLPrepare (continued)
ValueStatistic
Estimated query cost.EstimatedCost
Valid types are: Insert, Delete, Update, Select.StatementType
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.
SQLCompileTime
Prepare error code, if any. A zero (0) indicates that the
prepare was successful.
ErrorCode
SQLFetch
SQLFetch statistics are written to the alternate EMS collector at the time a statement is closed.
Table 6 Statement Statistics - SQLFetch
ValueStatistic
Unique session ID generated by the MXCS SQL server at
the time the connection is established.
Session ID
STATEMENT:SQLFetch/SQLClose (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
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
Total MXCS SQL server real time, in microseconds, from
the time the fetch was prepared to the time it was closed.
ODBCElapsedTime
Total MXCS SQL server CPU process time, in microseconds,
from the time the fetch was prepared to the time it was
closed.
ODBCExecutionTime
Total number of executes performed on the statement.TotalExecutes
Session Statistics - Summaries and Values
Session statistics are written to the alternate EMS collector at the time a connection is made (see
Table 7 (page 36)) and when the session is terminated (see Table 8 (page 36)).
Resource Statistics 35