beautypg.com

HP Neoview Release 2.4 Software User Manual

Page 61

background image

Table 3-13 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

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 3-14 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 3-15 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

SESSION_END_DATETIME, SESSION_END_DATE,
SESSION_END_TIME

END_ENTRY_ID_LCT

Column Removed - Duplicate of SESSION_START_TIME

START_TIME

Column Removed - Duplicate of SESSION_END_TIME

END_TIME

TOTAL_MASTER_EXEC_EXECUTION_TIME

TOTAL_ODBC_EXECUTION_TIME

Summary of Field Definition Changes from Repository 2.1

61