Hp Neoview Release 2.5 Software Manual do Utilizador descarregar pdf (Página 49)

Table 3-8 SPACE_PARTITION_DETAIL_VW1 Field Definitions (continued)

DescriptionData TypeField Name

Crash open. For disk objects other than SQL

shorthand views:

1 = if the object was open with write access

when a system failure occurred and the

object has not been opened since

0 = otherwise

CHAR(1)CRASH_OPEN

Incomplete SQL DDL operation. For SQL

tables and indexes:

1 = if the object has the D flag set

0 = otherwise

The D flag is an internal setting for

incomplete SQL DDL operations.

CHAR(1)INCOMPLETE_SQL_DDL

Unreclaimed free space. For SQL tables and

indexes:

1 = if the object has the F flag set

0 = otherwise

The F flag is an internal setting for unclaimed

free space.

CHAR(1)UNRECLAIMED_FREE_SPACE

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

Space Management Views and Sample Query Views for Space Management 49

1 2 ... 44 45 46 47 48 49 50 51 52 53 54 ... 141 142

Comentários a estes Manuais

Sem comentários

Hp Neoview Release 2.5 Software Manual do Utilizador Página 49

Comentários a estes Manuais

Manuais e produtos relacionados com Software Hp Neoview Release 2.5 Software