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

DescriptionStatistic
Unique statement ID generated by the MXCS SQL server
at the time the PREPARE statement 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
(ins/upd/del) Number of rows that were inserted, updated,
or deleted.
NumberOfRows
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
Statement Statistics: SQLExecDirect
SQLExecDirect statistics are written to the alternate EMS collector at the time an EXECUTE 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:SQLExecDirect (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 returned by the SQL compiler.EstimatedCost
Valid types are: Insert, Delete, Update, Select.StatementType
Total MXCS SQL server real time, in microseconds, from
the time the execdirect started to the time the results are
sent back.
ODBCElapsedTime
Total MXCS SQL server CPU process time, in microseconds,
from the time the execdirect started to the time the results
are sent back.
ODBCExecutionTime
(ins/upd/del) Number of rows that were inserted, updated,
or deleted.
NumberOfRows
Execdirect error code, if any. A zero (0) indicates that the
execdirect was successful.
ErrorCode
Cumulative number of rows accessed.RowsAccessed
44 Starting, Configuring, and Managing MXCS