Hp Neoview Release 2.3 Software Uživatelský manuál stáhnout pdf (Strana 60)

Table 3-16 Changes in Field Definitions for QUERY_RUNTIME_STATS_V1 from Repository 2.2 to

Repository 2.3 (continued)

Change in Repository 2.3Field Name in Repository 2.2

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_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

UPDATE_STATS_RUNNING_TSUPDATE_STATS_RUNNING_DATE and

UPDATE_STATS_RUNNING_TIME

METRIC_SUBMITTED_TS_UTCENTRY_DATE_UTC and ENTRY_TIME_UTC

UPDATE_TSUPDATE_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 viewMISSING_STATS_SEQ_NUM

No longer present in the viewMISSING_STATS_SEQ_SIZE

No longer present in the viewREPAIR_ACTION_SEQ_NUM

No longer present in the viewREPAIR_ACTION_SEQ_SIZE

No longer present in the viewMETRIC_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.—

60 Repository Views

1 2 ... 55 56 57 58 59 60 61 62 63 64 65 ... 73 74

Komentáře k této Příručce

Žádné komentáře

Hp Neoview Release 2.3 Software Uživatelský manuál Strana 60

Komentáře k této Příručce

Související produkty a manuály pro Software Hp Neoview Release 2.3 Software