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

Starting, Configuring, and Managing MXCS
HP NonStop SQL/MX Connectivity Service Manual—640327-001
3-10
Resource Statistics
the text of the SQL query for individual SQL statements. See Example resource
statistics output for three selected options on page 3-15.
Use NSM/web or MXCI to select these options for collecting resource statistics. See
Starting Statistics Collection on page 3-17.
Statement Statistics - Statements and Values
SQL Statement
Statement statistics are written to the alternate EMS collector at the time a Prepare
statement is received.
SQLExecute
SQLExecute statistics are written to the alternate EMS collector at the time an Execute
statement is received.
Table 3-2. Statement Statistics - SQL Statement
Statistic Value
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 0 (zero) and is incremented by 1 with each new record.
StatementID Unique statement ID generated by the MXCS SQL server at the time
the Prepare command is received.
SQL Text Text of the SQL statement. This field can be distributed in multiple
messages.
Table 3-3. Statement Statistics - SQLExecute
Statistic Value
Session ID Unique session ID generated by the MXCS SQL server at the time
the connection is established.
Message Attribute STATEMENT:SQLExecute (the Statistics option that was selected.)
Sequence Number Message sequence number generated by MXCS. The number
begins with 0 (zero) and is incremented by 1 with each new record.
StatementID Unique statement ID generated by the MXCS SQL server at the
time the Prepare command is received.
ODBCElapsedTime Total MXCS SQL server real time, in microseconds, from the time
the execute started to the time the results are sent back.