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

Starting, Configuring, and Managing MXCS
HP NonStop SQL/MX Connectivity Service Manual—524944-008
3-14
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
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
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