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

Table 7 Session Statistics - Connection Information
ValueStatistic
Unique session ID generated by the MXCS SQL server at
the time the connection is established.
Session ID
SESSION:ConnectionInformation (Statistics option that was
selected)
Message Attribute
SESSION:ConnectionInformation Authentication failed (for
unsuccessful connections due to incorrect password)
SESSION:ConnectionInformation Authentication failed;
password expired (for unsuccessful connections due to
password expiry).
Message sequence number generated by MXCS. The
number begins with 0 (zero) and is incremented by 1 with
each new record.
Sequence Number
Name of the MXCS component to which the statistics apply.Component
User name logged into the session (the logical name used
at the time of connection).
UserName
User ID that is logged into the session.UserID
Client workstation TCP/IP name or the NetBios/network
name.
ClientID
Client application name or the main window caption.Application ID
Client data source name used at the time of connection.DataSource
Name of the NonStop server used by the data source.NodeName
NonStop Kernel CPU number in which the MXCS server is
running, followed by the process ID of the server.
CpuPin
Table 8 Session Statistics - Session Summary
ValueStatistic
Unique session ID generated by the MXCS SQL server at
the time the connection is established.
Session ID
SESSION:Summary (Statistics option that was selected).Message Attribute
Message sequence number generated by MXCS. The
number begins with zero (0) and is incremented by 1 with
each new record.
Sequence Number
Time when the connection request was received.StartTime
Time when the session was terminated due to an
application request or a server idle timeout.
EndTime
Execution priority of the MXCS process at the time the
connection request is received.
StartPriority
Total MXCS SQL server CPU process time, in microseconds,
from the time the connection started to the time the
TotalOdbcExecutionTime
connection closed. Does not include SQL/MX compiler
time.
Total MXCS SQL server real time, in microseconds, from
the time the connection started to the time the connection
closed.
TotalOdbcElapsedTime
Total number of SQL INSERT statements sent by the
ODBC/MX driver to the MXCS SQL server. DOes not
include internally generated SQL statements.
TotalInsertStmtsExecuted
36 Starting, Configuring, and Managing MXCS