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

DescriptionStatistic
Total number of SQL DELETE 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 UPDATE statements sent by the HP
ODBC driver to the MXCS SQL server; does not include
internally generated SQL statements.
TotalUpdateStmtsExecuted
Total number of SQL SELECT statements sent by the HP
ODBC driver to the MXCS SQL server; does not include
internally generated SQL statements.
TotalSelectStmtsExecuted
Total number of SQL Catalog statements sent by the HP
ODBC driver to the MXCS SQL server.
TotalCatalogStmts
Total number of SQLPrepare calls.TotalPrepares
Total number of SQLExecute calls.TotalExecutes
Total number of SQLFetch calls.TotalFetches
Total number of SQLClose calls.TotalCloses
Total number of SQLExecDirect calls.TotalExecDirects
Total number of SQL statement execution errors detected
by the MXCS SQL server.
TotalErrors
Total number of SQL statement execution warnings detected
by the MXCS SQL server.
TotalWarnings
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):
DescriptionStatistic
Unique session ID generated by the MXCS SQL server at
the time the connection is established.
Session ID
STATEMENT:SQLStatement (the 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
Text of the SQL statement. This field can be distributed in
multiple messages.
SQL Text
Statement Statistics: SQLExecute
SQLExecute 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 server at the
time the connection is established.
Session ID
STATEMENT:SQLExecute (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
Resource Statistics 43