Neoview Repository User Guide (R2.4 SP1)

C History of Changes for Repository
This is a chronological history of changes to Repository, beginning with Release 2.2.
• “Summary of Field Definition Changes for Repository 2.2” (page 115)
• “Summary of Field Definition Changes for Repository 2.3” (page 117)
• “Summary of Changes For Repository 2.4 SP1” (page 118)
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 C-1 Field Name Mapping from ACCESS_ODBCMX_QUERY_STATS_V1 to
ODBC_QUERY_STATS_V1
Field Name in ODBC_QUERY_STATS_V1Field Name in ACCESS_ODBCMX_QUERY_STATS_V1
NODE_IDCPU_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_COSTESTIMATED_COST
DISK_READSDISC_READS
LOCK_ESCALATIONSLOCKESCALATIONS
LOCK_WAITSLOCKWAITS
MESSAGE_BYTES_TO_DISKMSGSBYTESTODISC
MESSAGES_TO_DISKMSGSTODISC
QUERY_ELAPSED_TIMEODBC_ELAPSED_TIME
MASTER_EXEC_EXECUTION_TIMEODBC_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_NAMENODENAME
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 C-2 Field Name Mapping from ACCESS_ODBCMX_QUERY_STATS_V2 to
ODBC_QUERY_STATS_V2
Field Name in ODBC_QUERY_STATS_V2Field Name in ACCESS_ODBCMX_QUERY_STATS_V2
SEGMENT_NAMENODENAME
NODE_IDCPU_NUM
STATEMENT_TYPEQUERY_TYPE
STATEMENT_STATEQUERY_STATE
Summary of Field Definition Changes for Repository 2.2 115