beautypg.com

Odbc_session_stats_v2 fields – HP Neoview Release 2.5 Software User Manual

Page 37

background image

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