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

Table 3-11 SPACE_PARTITION_DETAIL_VW1 Field Definitions (continued)

DescriptionData TypeField Name

Current data size, in bytes, of the partition,

determined by the End of File (EOF)

indicator

LARGEINTSIZE_CURR_BYTES

Maximum size, in bytes, of the partitionLARGEINTMAX_SIZE_CURR_BYTES

Primary extent size in bytesLARGEINTPRIMARY_EXTENT_CURR

Secondary extent size in bytesLARGEINTSECONDARY_EXTENT_CURR

Maximum extent size in bytesLARGEINTMAX_EXTENT_CURR

Allocated extent numberLARGEINTALLOC_EXTENT_CURR

Record length in bytesLARGEINTRECORD_LEN_CURR_BYTES

Row count of the last UPDATE STATISTICS

operation

LARGEINTSTATS_ROWCOUNT_CURR_NUM

Timestamp, in Local Civil Time, when

UPDATE STATISTICS was last run

LARGEINTSTATS_CURR_LCT_JTS

Timestamp, in Coordinated Universal Time,

when UPDATE STATISTICS was last run

LARGEINTSTATS_CURR_UTC_JTS

Index level of the last UPDATE STATISTICS

operation

LARGEINTINDEX_LEVELS_CURR

Real row-count number, available only when

the ROWC flag is set to Y

LARGEINTROW_COUNT_NUM

Timestamp, in Local Civil Time, when the

partition was created

LARGEINTCREATE_LCT_JTS

Timestamp, in Coordinated Universal Time,

when the partition was created

LARGEINTCREATE_UTC_JTS

Timestamp, in Local Civil Time, when the

partition was last modified

LARGEINTLAST_MODIFIED_LCT_JTS

Timestamp, in Coordinated Universal Time,

when the partition was last modified

LARGEINTLAST_MODIFIED_UTC_JTS

Timestamp, in Local Civil Time, when the

partition was last opened

LARGEINTLAST_OPEN_LCT_JTS

Timestamp, in Coordinated Universal Time,

when the partition was last opened

LARGEINTLAST_OPEN_UTC_JTS

Timestamp, in Local Civil Time, when the

partition was dropped

LARGEINTDROP_TIME_LCT_JTS

Timestamp, in Coordinated Universal Time,

when the partition was dropped

LARGEINTDROP_TIME_UTC_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

Space Management Views and Sample Query Views for Space Management 57

1 2 ... 52 53 54 55 56 57 58 59 60 61 62 ... 127 128

Comentarios a estos manuales

Sin comentarios

Hp Neoview Release 2.4 Software Manual de usuario Pagina 57

Comentarios a estos manuales

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