HP Neoview Release 2.5 Software - Manual (Page 135)

Summary of Field Definition Changes for Repository 2.2
The following field names changed between Repository 2.1 and Repository 2.2. If you have
already modified queries to reflect field names in Repository 2.2, you can ignore this section.
The following table shows how fields defined in the view ACCESS_ODBCMX_QUERY_STATS_V1
were renamed in the view ODBC_QUERY_STATS_V1.
Table F-4 Field Name Mapping from ACCESS_ODBCMX_QUERY_STATS_V1 to
ODBC_QUERY_STATS_V1
Field Name in ODBC_QUERY_STATS_V1 Field Name in ACCESS_ODBCMX_QUERY_STATS_V1
NODE_ID CPU_NUM
QUERY_EVENT_DATETIME_UTC,
QUERY_EVENT_DATE_UTC,
QUERY_EVENT_TIME_UTC ENTRY_ID
QUERY_EVENT_DATETIME, QUERY_EVENT_DATE,
QUERY_EVENT_TIME ENTRY_ID_LCT
EST_COST ESTIMATED_COST
DISK_READS DISC_READS
LOCK_ESCALATIONS LOCKESCALATIONS
LOCK_WAITS LOCKWAITS
MESSAGE_BYTES_TO_DISK MSGSBYTESTODISC
MESSAGES_TO_DISK MSGSTODISC
QUERY_ELAPSED_TIME ODBC_ELAPSED_TIME
MASTER_EXEC_EXECUTION_TIME ODBC_EXECUTION_TIME
Column Removed - Duplicate of
QUERY_ELAPSED_TIME TOTAL_ODBC_ELAPSED_TIME
Column Removed - Duplicate of
MASTER_EXEC_EXECUTION_TIME TOTAL_ODBC_EXECUTION_TIME
SEGMENT_NAME NODENAME
The following table shows how fields defined in the view ACCESS_ODBCMX_QUERY_STATS_V2
were renamed in the view ODBC_QUERY_STATS_V2.
Table F-5 Field Name Mapping from ACCESS_ODBCMX_QUERY_STATS_V2 to
ODBC_QUERY_STATS_V2
Field Name in ODBC_QUERY_STATS_V2 Field Name in ACCESS_ODBCMX_QUERY_STATS_V2
SEGMENT_NAME NODENAME
NODE_ID CPU_NUM
STATEMENT_TYPE QUERY_TYPE
STATEMENT_STATE QUERY_STATE
QUERY_START_DATETIME_UTC,
QUERY_START_DATE_UTC,
QUERY_START_TIME_UTC START_ENTRY_ID
QUERY_START_DATETIME, QUERY_START_DATE,
QUERY_START_TIME START_ENTRY_ID_LCT
QUERY_END_DATETIME_UTC,
QUERY_END_DATE_UTC, QUERY_END_TIME_UTC END_ENTRY_ID
Summary of Field Definition Changes for Repository 2.2 135