HP Neoview Release 2.5 Software - Manual (Page 36)

Table 3-3 ODBC_SESSION_STATS_V1 Field Definitions (continued)
Description Data Type Field Name
Name of the Neoview segment
used by the data source. CHAR(10) SEGMENT_NAME
Process name of the NDCS
server. CHAR(18) PROCESS_NAME
A deprecated internal
representation of a Neoview
role. CHAR(8) USER_ID
The name, used at time of
connection, to identify a
Neoview user. One or more
such names can map internally
to the same Neoview role. CHAR(20) USER_NAME
Time in microseconds spent on
login, including processing
steps on the Neoview platform
and, for database (LDAP) users,
time required for interaction
with the external authentication
server.
This metric does not include
processing steps on the
workstation where the logon
occurred.
LARGEINT TOTAL_LOGIN_ELAPSED_TIME_MCSEC
Time in microseconds spent on
communication with the
external authentication server,
including time waiting for
replies from the server. For
platform users, such as
super-user or SecurityAdmin,
the value is 0. LARGEINT LDAP_LOGIN_ELAPSED_TIME_MCSEC
The LDAP name of the user
who originated the session by
logging in to a workstation. If
the name is not available from
the ODBC driver, this field is
NULL. CHAR(128) or NCHAR(128) CLIENT_USER_NAME
VIEW NEO.HP_METRICS.ODBC_SESSION_STATS_V2
The Repository stores a start and end row for each ODBC statement EXECUTE (active or
historical). To access the rows separately, use ODBC_SESSION_STATS_V1. In contrast, the view
ODBC_SESSION_STATS_V2 converts this information so that a single row provides complete
information about the start and the end of a session for COMPLETED session.
You can also use this view to extract UNTERMINATED queries sessions. UNTERMINATED
sessions are sessions that are still active or that terminated abnormally.
This table indicates which fields are present for completed and incomplete sessions. The source
of data fields indicates whether the value is collected at the start of the session or at the end.
Unless indicated here, field descriptions are those provided above for ODBC_SESSION_STATS_V1.
Character columns use ISO88591 or UCS2 encoding, as appropriate to the Neoview platform
configuration. If the platform is UCS2 or SJIS, all character columns are created with CHARACTER
SET UCS2. If the platform is ISO88591, all CHAR columns are created with CHARACTER SET
ISO88591.
36 Repository Views