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

Starting, Configuring, and Managing MXCS
HP NonStop SQL/MX Connectivity Service Manual—640327-001
3-21
Collecting Server Statistics
Statement Statistics: SQL Statement
Statement 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):
TotalOdbcElapsedT
ime
Total MXCS SQL server real time, in microseconds, from the time the
connection started to the time the connection closed.
TotalInsertStmtsEx
ecuted
Total number of SQL INSERT statements sent by the HP ODBC driver
to the MXCS SQL server; does not include internally generated SQL
statements.
TotalDeleteStmtsEx
ecuted
Total number of SQL DELETE statements sent by the HP ODBC
driver to the MXCS SQL server; does not include internally generated
SQL statements.
TotalUpdateStmtsE
xecuted
Total number of SQL UPDATE statements sent by the HP ODBC
driver to the MXCS SQL server; does not include internally generated
SQL statements.
TotalSelectStmtsEx
ecuted
Total number of SQL SELECT statements sent by the HP ODBC
driver to the MXCS SQL server; does not include internally generated
SQL statements.
TotalCatalogStmts Total number of SQL Catalog statements sent by the HP ODBC driver
to the MXCS SQL server.
TotalPrepares Total number of SQLPrepare calls.
TotalExecutes Total number of SQLExecute calls.
TotalFetches Total number of SQLFetch calls.
TotalCloses Total number of SQLClose calls.
TotalExecDirects Total number of SQLExecDirect calls.
TotalErrors Total number of SQL statement execution errors detected by the
MXCS SQL server.
TotalWarnings Total number of SQL statement execution warnings detected by the
MXCS SQL server.
Statistic Description
Session ID Unique session ID generated by the MXCS SQL server at the time the
connection is established.
Message Attribute STATEMENT:SQLStatement (the 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.
SQL Text Text of the SQL statement. This field can be distributed in multiple
messages.