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

Starting, Configuring, and Managing MXCS
HP NonStop SQL/MX Connectivity Service Manual—640327-001
3-15
Resource Statistics
Example resource statistics output for three selected
options
The following example shows the resource statistics collected for the options SQL
Statement, SQLPrepare, and Session Summary. A separate EMS message is returned
for each option selected.
01-10-03 09:27:50 \ODBC.$Z1782 TANDEM.ODBCMX.G10 021035 ODBC/MX
Statistics:
Session ID: $SS:11:$Z1782:20011039272
Message Attribute:
STATEMENT:SQLStatement
Sequence Number: 0
Message Info:
StatementId:200110392749 SqlText:select * from employee
01-10-03 09:27:50 \ODBC.$Z1782 TANDEM.ODBCMX.G10 021035 ODBC/MX
Statistics:
Session ID: $SS:11:$Z1782:200110392729
Message Attribute:
STATEMENT:SQLPrepare
Sequence Number: 0
Message Info:
StatementId:200110392749
TotalUpdateStmtsExecuted Total number of SQL UPDATE statements sent by the
ODBC/MX driver to the MXCS SQL server. Does not include
internally generated SQL statements.
TotalSelectStmtsExecuted Total number of SQL SELECT statements sent by the
ODBC/MX driver to the MXCS SQL server. Does not include
internally generated SQL statements.
TotalCatalogStmts Total number of SQL Catalog statements sent by the
ODBC/MX 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.
Table 3-8. Session Statistics - Session Summary
Statistic Value