Hp Neoview Release 2.4 Software Manual de usuario descargar pdf (Pagina 61)

Table 3-12 SPACE_PARTITION_DETAIL_HISTORY_VW1 Field Definitions (continued)

DescriptionData TypeField Name

Timestamp, in Coordinated Universal Time,

when UPDATE STATISTICS was last run

LARGEINTSTATS_CURR_UTC_JTS

Timestamp, in Local Civil Time, when

UPDATE STATISTICS was last run

LARGEINTSTATS_CURR_LCT_JTS

Index level of the last UPDATE STATISTICS

operation

LARGEINTINDEX_LEVELS_CURR

Average value of INDEX_LEVELS_CURRLARGEINTINDEX_LEVELS_AVG

Minimum value of INDEX_LEVELS_CURRLARGEINTINDEX_LEVELS_MIN

Maximum value of INDEX_LEVELS_CURRLARGEINTINDEX_LEVELS_MAX

Real row-count number, available only when

the ROWC flag is set to Y

LARGEINTROW_COUNT_CURR_NUM

Average value of

ROW_COUNT_CURR_NUM

LARGEINTROW_COUNT_AVG_NUM

Minimum value of

ROW_COUNT_CURR_NUM

LARGEINTROW_COUNT_MIN_NUM

Maximum value of

ROW_COUNT_CURR_NUM

LARGEINTROW_COUNT_MAX_NUM

Timestamp, in Coordinated Universal Time,

when the partition was created

LARGEINTCREATE_UTC_JTS

Timestamp, in Coordinated Universal Time,

when the partition was last modified

LARGEINTLAST_MODIFIED_UTC_JTS

Timestamp, in Coordinated Universal Time,

when the partition was last opened

LARGEINTLAST_OPEN_UTC_JTS

Timestamp, in Coordinated Universal Time,

when the partition was dropped

LARGEINTDROP_TIME_UTC_JTS

Timestamp, in Local Civil Time, when the

partition was created

LARGEINTCREATE_LCT_JTS

Timestamp, in Local Civil Time, when the

partition was last modified

LARGEINTLAST_MODIFIED_LCT_JTS

Timestamp, in Local Civil Time, when the

partition was last opened

LARGEINTLAST_OPEN_LCT_JTS

Timestamp, in Local Civil Time, when the

partition was dropped

LARGEINTDROP_TIME_LCT_JTS

The application-defined codeINT UNSIGNEDFILE_CODE

Owner of the fileCHAR(64)FILE_OWNER_NAME

One of these categories:

SQL Permanent Space

SQL System Space

SQL Volatile Space

Transform Ghost Objects

Transporter Staging Tables

CHAR(128)CATEGORY_TYPE

User or SystemCHAR(20)CATEGORY_NAME

Size allocated by the file systemLARGEINTALLOCATED_SIZE_BYTES

Percentage of disk space currently in useNUMERIC(128, 2)FULL_PCT

Space Management Views and Sample Query Views for Space Management 61

1 2 ... 56 57 58 59 60 61 62 63 64 65 66 ... 127 128

Comentarios a estos manuales

Sin comentarios

Hp Neoview Release 2.4 Software Manual de usuario Pagina 61

Comentarios a estos manuales

Relacionado con productos y manuales para Software Hp Neoview Release 2.4 Software