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

DescriptionStatistic
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
Statement Statistics: SQLPrepare
SQLPrepare statistics are written to the alternate EMS collector at the time a PREPARE statement is
received (listed in the order written in the event message):
DescriptionStatistic
Unique session ID generated by the MXCS SQL server at
the time the connection is established.
Session ID
STATEMENT:SQLPrepare (Statistics option that was
selected.)
Message Attribute
Message sequence number generated by MXCS. The
number begins with zero (0) 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 statement is received.
StatementID
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 started 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
Statement Statistics: SQLFetch
SQLFetch statistics are written to the alternate EMS collector at the time a statement is closed (listed
in the order written in the event message):
DescriptionStatistic
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 zero (0) 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 statement 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
Resource Statistics 45