Manualshelf

SQL/MX Connectivity Service Manual (SQL/MX 3.x)

ManualsBrandsHP ManualsServerHP Integrity NonStop J-Series
51525354555657585960
Starting, Configuring, and Managing MXCS
HP NonStop SQL/MX Connectivity Service Manual—640327-001
3-24
Tracing Server Activity
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):
Tracing Server Activity
You can trace MXCS activity for a data source in order to track error conditions and
server function.
Server data collected:
StatementType Valid types are: Insert, Delete, Update, Select.
SQLCompileTime 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.
ErrorCode Prepare error code, if any. A zero (0) indicates that the prepare was
successful.
Statistic Description
Session ID Unique session ID generated by the MXCS SQL server at the time the
connection is established.
Message Attribute STATEMENT:SQLFetch/SQLClose (Statistics option that was
selected.)
Sequence Number Message sequence number generated by MXCS The number begins
with zero (0) and is incremented by 1 with each new record.
StatementID Unique statement ID generated by the MXCS SQL server at the time
the PREPARE statement is received.
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.
TotalOdbcElapsedT
ime
Total MXCS SQL server real time, in microseconds, from the time the
fetch was prepared to the time it was closed.
TotalOdbcExecutio
nTime
Total MXCS SQL server CPU process time, in microseconds, from the
time the fetch was prepared to the time it was closed.
TotalExecutes Total number of executes performed on the statement.