Manualshelf

SQL/MX Connectivity Service Manual for SQL/MX Release 3.1 (H06.23+, J06.12+)

ManualsBrandsHP ManualsServerHP Integrity NonStop H-Series
41424344454647484950
Starting, Configuring, and Managing MXCS
HP NonStop SQL/MX Connectivity Service Manual for SQL/MX Release 3.1—663856-001
3-14
Resource Statistics
Table 3-7. Session Statistics - Connection Information
Statistic Value
Session ID Unique session ID generated by the MXCS SQL server at the time
the connection is established.
Message Attribute SESSION:ConnectionInformation (Statistics option that was
selected)
SESSION:ConnectionInformation Authentication failed (for
unsuccessful connections due to incorrect password)
SESSION:ConnectionInformation Authentication failed; password
expired (for unsuccessful connections due to password expiry).
Sequence Number Message sequence number generated by MXCS. The number
begins with 0 (zero) and is incremented by 1 with each new record.
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.