Odbc_session_stats_v2 fields – HP Neoview Release 2.5 Software User Manual
Page 37
The primary key for ODBC_SESSION_STATS_V2 field definition is SEGMENT_ID, NODE_ID,
and SESSION_EVENT_DATETIME_UTC.
Table 3-4 ODBC_SESSION_STATS_V2 Fields
Source and
Notes
Data Type
Incomplete Sessions
Complete Sessions
START
CHAR(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)
PROCESS_NAME
PROCESS_NAME
START
CHAR(108)
SESSION_ID
SESSION_ID
START
CHAR(8)
USER_ID
USER_ID
START
CHAR(20)
USER_NAME
USER_NAME
START
CHAR(15)
CLIENT_ID
CLIENT_ID
START
CHAR(130)
APPLICATION_ID
APPLICATION_ID
START
CHAR(20)
COMPONENT_NAME
COMPONENT_NAME
START
CHAR(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
END, or
NULL for an
incomplete
session
TIMESTAMP
SESSION_START_DATETIME_
UTC
SESSION_END_DATETIME_UTC
ODBC Session Data
37