HP Neoview Release 2.4 Software - Manual (Page 41)

The primary key for ODBC_SESSION_STATS_V2 field definition is SEGMENT_ID, NODE_ID,
and SESSION_EVENT_DATETIME_UTC.
Table 3-6 ODBC_SESSION_STATS_V2 Fields
Source and
Notes
Data Type Incomplete Sessions Complete Sessions
START CHAR(10) or
NCHAR(10) SEGMENT_NAME SEGMENT_NAME
START INTEGER UNSIGNED SEGMENT_ID SEGMENT_ID
START INTEGER UNSIGNED NODE_ID NODE_ID
START INTEGER UNSIGNED PIN PIN
END, or
NULL for an
incomplete
session SMALLINT UNSIGNED START_PRIORITY START_PRIORITY
START CHAR(18) or
NCHAR(18) PROCESS_NAME PROCESS_NAME
START CHAR(108) or
NCHAR(108) SESSION_ID SESSION_ID
START CHAR(8) or NCHAR(8) USER_ID USER_ID
START CHAR(20) or
NCHAR(20) USER_NAME USER_NAME
START CHAR(15) or or
NCHAR(15) CLIENT_ID CLIENT_ID
START CHAR(130) or
NCHAR(130) APPLICATION_ID APPLICATION_ID
START CHAR(20) or
NCHAR(20) COMPONENT_NAME COMPONENT_NAME
START CHAR(128) or
NCHAR(128) DATASOURCE DATASOURCE
START SMALLINT UNSIGNED SEQUENCE_NUM SEQUENCE_NUM
START TIMESTAMP SESSION_START_DATETIME SESSION_START_DATETIME
START DATE SESSION_START_DATE SESSION_START_DATE
START TIME SESSION_START_TIME SESSION_START_TIME
START TIMESTAMP SESSION_START_DATETIME_UTC SESSION_START_DATETIME_UTC
START DATE SESSION_START_DATE_UTC SESSION_START_DATE_UTC
START TIME SESSION_START_TIME_UTC SESSION_START_TIME_UTC
END, or
NULL for an
incomplete
session TIMESTAMP SESSION_START_DATETIME SESSION_END_DATETIME
END, or
NULL for an
incomplete
session DATE SESSION_END_DATE SESSION_END_DATE
END, or
NULL for an
incomplete
session TIME SESSION_ END _TIME SESSION_ END _TIME
ODBC Session Data 41