beautypg.com

Session statistics: connection information, Session statistics: session summary information – HP Neoview Release 2.4 Software User Manual

Page 42

background image

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):

Description

Statistic

Unique session ID generated by the NDCS 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 NDCS. The number begins with zero (0) and is
incremented by 1 with each new record.

Sequence Number

Name of the NDCS 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 NDCS 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):

Description

Statistic

Unique session ID generated by the NDCS 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 NDCS. 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 NDCS process at the time the connection request is received.

StartPriority

Total NDCS SQL server CPU process time, in microseconds, from the time the
connection started to the time the connection closed; does not include Neoview SQL
compiler time.

TotalOdbcExecution Time

Total NDCS 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 NDCS
SQL server; does not include internally generated SQL statements.

TotalInsertStmtsExecuted

Total number of SQL DELETE statements sent by the HP ODBC driver to the NDCS
SQL server; does not include internally generated SQL statements.

TotalDeleteStmtsExecuted

Total number of SQL UPDATE statements sent by the HP ODBC driver to the NDCS
SQL server; does not include internally generated SQL statements.

TotalUpdateStmtsExecuted

42

Perform Basic HPDM Operations