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

Session Statistics: Connection Information
Session statistics are written to the alternate EMS collector at the time the connection is made (listed
in the order written in the event message):
DescriptionStatistic
Unique session ID generated by the MXCS server at the
time the connection is established.
Session ID
SESSION:ConnectionInformation (the 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
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.ApplicationId
Client data source name used at the time of connection.DataSource
Name of the Neoview platform used by the data source.NodeName
Operating system CPU number in which the MXCS server
is running, followed by the process ID of the server.
CpuPin
Session Statistics: Session Summary Information
Session statistics are written to the alternate EMS collector when the session is terminated (listed
in the order written in the event message):
DescriptionStatistic
Unique session ID generated by the MXCS SQL server at
the time the connection is established.
Session ID
SESSION:Summary (the 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
TotalOdbcExecution Time
connection closed; does not include Neoview SQL 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 HP
ODBC driver to the MXCS SQL server; does not include
internally generated SQL statements.
TotalInsertStmtsEx ecuted
42 Starting, Configuring, and Managing MXCS