MX 2.x)

Starting, Configuring, and Managing MXCS

HP NonStop SQL/MX Connectivity Service Manual—524944-008

3-13

Resource Statistics

Table 3-8. Session Statistics - Session Summary

Statistic Value

Session ID Unique session ID generated by the MXCS SQL server at

the time the connection is established.

Message Attribute SESSION:Summary (Statistics option that was selected).

Sequence Number Message sequence number generated by MXCS. The

number begins with zero (0) and is incremented by 1 with

each new record.

StartTime Time when the connection request was received.

EndTime Time when the session was terminated due to an application

request or a server idle timeout.

StartPriority Execution priority of the MXCS process at the time the

connection request is received.

TotalOdbcExecutionTime Total MXCS SQL server CPU process time, in

microseconds, from the time the connection started to the

time the connection closed. Does not include SQL/MX

compiler time.

TotalOdbcElapsedTime Total MXCS SQL server real time, in microseconds, from the

time the connection started to the time the connection

closed.

TotalInsertStmtsExecuted Total number of SQL INSERT statements sent by the

ODBC/MX driver to the MXCS SQL server. DOes not

include internally generated SQL statements.

TotalDeleteStmtsExecuted Total number of SQL DELETE statements sent by the

ODBC/MX driver to the MXCS SQL server. Does not include

internally generated SQL statements.

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.