HP Neoview Release 2.4 Software User Manual
Page 37
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