Neoview Workload Management Services Guide (R2.5)

Understand the Session Statistics
This table describes the Session Statistics fields:
DescriptionName
Name of the application that initiated the sessionApplication Id
Client host nameClient Id
Name of the user who originated the session by logging in to the Neoview platform.
If the name is not available from the ODBC driver, this field is NULL.
Client User Name
Name of the NDCS component to which the statistics apply (for example,
ODBC_Server)
Component Name
Name of the data source name for the connectionDatasource
Time in microseconds spent on communication with the external authentication server,
including time waiting for replies from the server. For platform users, the value is 0.
Ldap Login Elapsed Time
Mcsec
Repository-assigned value that is used internallyMetric Class Id
Repository-assigned value that is used internallyMetric Class Version
Processing node number of the NDCS server that generated the sessionNode Id
Process identification number of the NDCS serverPin
Process name of the NDCS serverProcess Name
Segment number of the NDCS server that reported the statisticsSegment Id
Name of the Neoview segment used by the data sourceSegment Name
Message sequence number generated by NDCS. Numbering starts at 0 and is
incremented by 1 for each new record.
Sequence Num
ANSI SQL date, in Local Civil Time, when the statistics were recorded in the
Repository.
Session Event Date
ANSI SQL date, in Coordinated Universal Time, when the statistics were recorded in
the Repository
Session Event Date Utc
ANSI SQL Timestamp, in Local Civil Time, indicating when the statistics were recorded
in the Repository
Session Event Datetime
ANSI SQL Timestamp, in Coordinated Universal Time, indicating when the statistics
were recorded in the Repository
Session Event Datetime Utc
ANSI SQL time, in Local Civil Time, when the statistics were recorded in the RepositorySession Event Time
ANSI SQL time, in Coordinated Universal Time, when the statistics were recorded
in the Repository
Session Event Time Utc
Unique session ID generated by the NDCS server when the connection was establishedSession Id
START if this record contains information collected at the start of the session, or END
if it contains statistics collected at the end of the session
Session Status
Execution priority of the NDCS process at the time the connection request was receivedStart Priority
Total number of SQL catalog statements sent by the HP ODBC driver to the NDCS
server
Total Catalog Stmts
Total number of SQL CLOSE calls sent by the HP ODBC driver to the NDCS serverTotal Closes
Total number of SQL DELETE statements sent by the HP ODBC driver to the NDCS
server. Does not include internally generated SQL statements.
Total Delete Stmts Executed
Total number of SQL statement execution errors detected by the NDCS serverTotal Errors
Total number of SQLExecDirect callsTotal Execdirects
138 Monitoring and Managing Workloads