HP Neoview Release 2.4 Software - Manual (Page 120)

The following table shows how fields defined in the view QUERY_RUNTIME_STATS_V1 were
renamed in Repository 2.3.
Table D-2 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 D-3 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. —
REORG_STATUS is new in Repository 2.3. —
MISSING_STATS_COUNT is new in Repository 2.3. —
120 History of Field Changes for Repository