beautypg.com

HP Neoview Release 2.4 Software User Manual

Page 37

background image

Table 3-4 ODBC_SESSION_STATS_V2 Fields (continued)

Source and Notes

Data Type

Incomplete Sessions

Complete Sessions

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

END, or NULL for an incomplete
session

DATE

SESSION_END_DATE_UTC

SESSION_END_DATE_UTC

END, or NULL for an incomplete
session

TIME

SESSION_ END _TIME_UTC

SESSION_ END _TIME_UTC

'INCOMPLETE' or 'COMPLETE'

CHAR(14)

SESSION_STATE

SESSION_STATE

END, or NULL for an incomplete
session

LARGEINT

TOTAL_CATALOG_STMTS

END, or NULL for an incomplete
session

LARGEINT

TOTAL_CLOSES

END, or NULL for an incomplete
session

LARGEINT

TOTAL_DELETE_STMTS_EXECUTED

END, or NULL for an incomplete
session

LARGEINT

TOTAL_ERRORS

END, or NULL for an incomplete
session

LARGEINT

TOTAL_EXECDIRECTS

END, or NULL for an incomplete
session

LARGEINT

TOTAL_EXECUTES

END, or NULL for an incomplete
session

LARGEINT

TOTAL_FETCHES

END, or NULL for an incomplete
session

LARGEINT

TOTAL_INSERT_STMTS_EXECUTED

END, or NULL for an incomplete
session

LARGEINT

TOTAL_ODBC_ELAPSED_TIME

END, or NULL for an incomplete
session

LARGEINT

TOTAL_MASTER_EXEC_EXECUTION_
TIME

ODBC Session Data

37