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