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

Starting, Configuring, and Managing MXCS
HP NonStop SQL/MX Connectivity Service Manual—640327-001
3-14
Resource Statistics
Component Name of the MXCS component to which the statistics apply.
UserName User name logged into the session (the logical name used at the
time of connection).
UserID User ID that is logged into the session.
ClientID Client workstation TCP/IP name or the NetBios/network name.
Application ID Client application name or the main window caption.
DataSource Client data source name used at the time of connection.
NodeName Name of the NonStop server used by the data source.
CpuPin NonStop Kernel CPU number in which the MXCS server is running,
followed by the process ID of the server.
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.
Table 3-7. Session Statistics - Connection Information
Statistic Value