HP Neoview Release 2.4 Software - Manual (Page 40)

Table 3-5 ODBC_SESSION_STATS_V1 Field Definitions (continued)
Description Data Type Field Name
Process identification number
of the NDCS server. INTEGER UNSIGNED PIN
Execution priority of the NDCS
process at the time the
connection request was
received. SMALLINT UNSIGNED START_PRIORITY
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. CHAR(5) or NCHAR(5) SESSION_STATUS
Client application name or
main window caption. CHAR(130) or NCHAR(130) APPLICATION_ID
Client workstation TCP/IP or
NetBios/network name. CHAR(15) or NCHAR(15) CLIENT_ID
Name of the NDCS component
to which the statistics apply,
e.g., ODBC_Server. CHAR(20) or or NCHAR(20) COMPONENT_NAME
Client data source name used
at the time of the connection. CHAR(128) or NCHAR(128) DATASOURCE
Name of the Neoview segment
used by the data source. CHAR(10) or NCHAR(10) SEGMENT_NAME
Process name of the NDCS
server. CHAR(18) or NCHAR(18) PROCESS_NAME
A deprecated internal
representation of a Neoview
role. CHAR(8) or or NCHAR(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) or NCHAR(20) 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. In the following table:
• If a data type is given as CHAR or NCHAR, then CHAR applies if the character set is
ISO88591, and NCHAR applies if the character set is UCS2.
• If a data type is given as VARCHAR or NCHAR VARYING, the VARCHAR applies if the
character set is ISO88591, and NCHAR VARYING applies if the character set is UCS2.
40 Repository Views