beautypg.com

HP Neoview Release 2.4 Software User Manual

Page 122

background image

Table D-5 Field Name Mapping from ACCESS_ODBCMX_QUERY_STATS_V2 to

ODBC_QUERY_STATS_V2 (continued)

Field Name in ODBC_QUERY_STATS_V2

Field Name in ACCESS_ODBCMX_QUERY_STATS_V2

QUERY_END_DATETIME, QUERY_END_DATE,
QUERY_END_TIME

END_ENTRY_ID_LCT

EST_COST

ESTIMATED_COST

QUERY_ELAPSED_TIME

ODBC_ELAPSED_TIME

MASTER_EXEC_EXECUTION_TIME

ODBC_EXECUTION_TIME

DISK_READS

DISC_READS

LOCK_ESCALATIONS

LOCKESCALATIONS

LOCK_WAITS

LOCKWAITS

MESSAGE_BYTES_TO_DISK

MSGSBYTESTODISC

MESSAGES_TO_DISK

MSGSTODISC

The following table shows how fields defined in the view
ACCESS_ODBCMX_SESSION_DATA_V1 were renamed in the view ODBC_SESSION_STATS_V1.

Table D-6 Field Name Mapping from ACCESS_ODBCMX_SESSION_DATA_V1 to
ODBC_SESSION_STATS_V1.

Field Name in ODBC_SESSION_STATS_V1

Field Name in ACCESS_ODBCMX_SESSION_DATA_V1

NODE_ID

CPU_NUM

SESSION_EVENT_DATETIME_UTC,
SESSION_EVENT_DATE_UTC,
SESSION_EVENT_TIME_UTC

ENTRY_ID

SESSION_EVENT_DATETIME, SESSION_EVENT_DATE,
SESSION_EVENT_TIME

ENTRY_ID_LCT

TOTAL_MASTER_EXEC_EXECUTION_TIME

TOTAL_ODBC_EXECUTION_TIME

Column Removed

END_TIME

SEGMENT_NAME

NODENAME

Column Removed

START_TIME

The following table shows how fields defined in the view
ACCESS_ODBCMX_SESSION_DATA_V2 were renamed in the view ODBC_SESSION_STATS_V2.

Table D-7 Field Name Mapping from ACCESS_ODBCMX_SESSION_DATA_V2 to
ODBC_SESSION_STATS_V2

Field Name in ODBC_SESSION_STATS_V2

Field Name in ACCESS_ODBCMX_SESSION_DATA_V2

SEGMENT_NAME

NODENAME

NODE_ID

CPU_NUM

SESSION_START_DATETIME_UTC,
SESSION_START_DATE_UTC,
SESSION_START_TIME_UTC

START_ENTRY_ID

SESSION_START_DATETIME, SESSION_START_DATE,
SESSION_START_TIME

START_ENTRY_ID_LCT

SESSION_END_DATETIME_UTC,
SESSION_END_DATE_UTC, SESSION_END_TIME_UTC

END_ENTRY_ID

122

History of Field Changes for Repository