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

Table 8 Session Statistics - Session Summary (continued)
ValueStatistic
Total number of SQL DELETE statements sent by the
ODBC/MX driver to the MXCS SQL server. Does not
include internally generated SQL statements.
TotalDeleteStmtsExecuted
Total number of SQL UPDATE statements sent by the
ODBC/MX driver to the MXCS SQL server. Does not
include internally generated SQL statements.
TotalUpdateStmtsExecuted
Total number of SQL SELECT statements sent by the
ODBC/MX driver to the MXCS SQL server. Does not
include internally generated SQL statements.
TotalSelectStmtsExecuted
Total number of SQL Catalog statements sent by the
ODBC/MX 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
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
nl
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
EstimatedCost:0
StatementType:select
SQLCompileTime:1106627 ErrorCode:0
01-10-03 09:27:29 \ODBC Z1782 TANDEM.ODBCMX.G10 021035 ODBC/MX
Statistics:
Session ID: $SS:11:$Z1782:200110392729
Message Attribute: SESSION:SessionSummary
Sequence Number: 0
Message Info:
StartTime:2001/10/3 9:27:29.45
EndTime:2001/10/3 9:47:36.44
StartPriority:168 TotalOdbcExecutionTime:332432
TotalOdbcElapsedTime :2347517
TotalInsertStmtsExecuted:2
TotalDeleteStmtsExecuted:0
TotalUpdateStmtsExecuted:0
TotalSelectStmtsExecuted:2
TotalCatalogStmts:0 TotalPrepares:2 TotalExecutes:2
Resource Statistics 37