HP Neoview Release 2.5 Software - Manual (Page 136)

Table F-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 F-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 F-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
136 History of Field Changes for Repository