Neoview Repository User Guide (R2.4 SP1)
Table C-4 Field Name Mapping from ACCESS_ODBCMX_SESSION_DATA_V2 to
ODBC_SESSION_STATS_V2 (continued)
Field Name in ODBC_SESSION_STATS_V2Field Name in ACCESS_ODBCMX_SESSION_DATA_V2
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_TIMESTART_TIME
Column Removed - Duplicate of SESSION_END_TIMEEND_TIME
TOTAL_MASTER_EXEC_EXECUTION_TIMETOTAL_ODBC_EXECUTION_TIME
Summary of Field Definition Changes for Repository 2.3
This section describes field definition changes between Repository 2.2 and Repository 2.3.
The following table shows how fields defined in the view QUERY_RUNTIME_STATS_V1 were
renamed in Repository 2.3.
Table C-5 Field Definition Changes for QUERY_RUNTIME_STATS_V1 from Repository 2.2 to Repository
2.3
Change in Repository 2.3Field Name in Repository 2.2
Now has data type INTERVAL SECOND(12,6).SQL_PROCESS_BUSY_TIME
Now has data type INTERVAL SECOND(12,6).QUE_TIME
Value is now precise to the microsecond, or NULL if data
is unavailable.
MASTER_EXECUTOR_BUSY_TIME
Value is now precise to the microsecond, or NULL if data
is unavailable. Value is updated when the entry is
refreshed.
COMPILE_ELAPSED_TIME
Now NULL for queries in which rows cannot be updated,
inserted, or deleted, e.g., SELECTs
NUM_ROWS_UID
Value is updated when the entry is refreshed.COMPILE_START_TS
Value is updated when the entry is refreshed.COMPILE_END_TS
New METRIC_CTRL field introduced–
The following table shows how fields in the view TABLE_STATS_V1 were redefined in the view
TABLE_STATS_V2.
Table C-6 Field Name Mapping from TABLE_STATS_V1 to TABLE_STATS_V2
Change in TABLE_STATS_V2Field Name in TABLE_STATS_V1
METRIC_SUBMITTED_TSMETRIC_SUBMITTED_DATE and
METRIC_SUBMITTED_TIME
LAST_UPDATE_STATS_TSLAST_UPDATE_STATS_DATE and
LAST_UPDATE_STATS_TIME
MIN_UPDATE_STATS_TSMIN_UPDATE_STATS_DATE and
MIN_UPDATE_STATS_TIME
Summary of Field Definition Changes for Repository 2.3 117