HP Neoview Release 2.4 Software - Manual (Page 62)

Summary of Field Definition Changes from Repository 2.2
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 3-16 Field Definition Changes for QUERY_RUNTIME_STATS_V1 from Repository 2.2 to
Repository 2.3
Change in Repository 2.3 Field 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 3-17 Field Name Mapping from TABLE_STATS_V1 to TABLE_STATS_V2
Change in TABLE_STATS_V2 Field Name in TABLE_STATS_V1
METRIC_SUBMITTED_TS METRIC_SUBMITTED_DATE and
METRIC_SUBMITTED_TIME
LAST_UPDATE_STATS_TS LAST_UPDATE_STATS_DATE and
LAST_UPDATE_STATS_TIME
MIN_UPDATE_STATS_TS MIN_UPDATE_STATS_DATE and
MIN_UPDATE_STATS_TIME
UPDATE_STATS_RUNNING_TS UPDATE_STATS_RUNNING_DATE and
UPDATE_STATS_RUNNING_TIME
METRIC_SUBMITTED_TS_UTC ENTRY_DATE_UTC and ENTRY_TIME_UTC
UPDATE_TS UPDATE_DATE and UPDATE_TIME
Now has datatype VARCHAR(1740) and includes a
cumulative list of columns that have missing statistics MISSING_STATS
Now defined as VARCHAR(1024) REPAIR_ACTION
No longer present in the view MISSING_STATS_SEQ_NUM
No longer present in the view MISSING_STATS_SEQ_SIZE
No longer present in the view REPAIR_ACTION_SEQ_NUM
No longer present in the view REPAIR_ACTION_SEQ_SIZE
No longer present in the view METRIC_SOURCE
LAST_REORG_TS is new in Repository 2.3. —
62 Repository Views