HP Neoview Release 2.3 Software - Manual (Page 38)

Table 3-5 ODBC_SESSION_STATS_V1 Field Definitions (continued)
Description Data Type Field Name
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 or NCHAR(20) USER_NAME
NOTE: The query ID has the following format:
MXIDversion segment node pin processStartTS sessionNum unLen userName
snLen sessionName
2 digits version number of ID version
3 digits segment number segment
2 digits processing node (CPU) number node
4 digits process identification number pin
18 digits time when the Master Executor
process started processStartTS
10 digits sequentially increasing session
number sessionNum
2 digits length of the user ALIAS name unLen
unLen bytes, maximum 32 actual user name userName
2 digits length of application-specified session
name snLen
snLen bytes, maximum 24 actual session name sessionName
The session ID consists of the first nine fields of the query ID. All fields are fixed length, except
the user name and session name. The ID has a total maximum length of 160.
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 semantics are those provided above for ODBC_SESSION_STATS_V1.
38 Repository Views