Single Table Analysis: Table Status

The Table Status tab page provides the following information:

Field Description

Partition Database partition number

Data Partition ID

Data partition ID Note

This field is only available if the related table is using the data partitioning feature (DPF).

End of the note.

Physical Size

Data Objects

Amount of disk space in KB that is physically allocated for the table For tables using multi dimensional clustering (MDC), the value displayed includes the size of the block map object. The displayed value represents the physical size of the base table only. Space that is consumed by LOB data, long data, indexes, and XML objects is reported by other fields as described in the following.

Long Objects Amount of disk space in KB that is physically allocated for long field data in a

table

LOB Objects Amount of disk space in KB that is physically allocated for long field data in a

table

XML Objects Amount of disk space in KB that is physically allocated for XML data in a

table

Index Objects Amount of disk space in KB that is physically allocated for the indexes

Logical Size

Data Objects

Amount of disk space in KB that is logically allocated for the table

For MDC tables, this size includes the logical size of the block map object. This size represents the logical size of the base table only. Space that is consumed by LOB data, long data, indexes, and XML objects is reported by other fields described in the following.

Long Objects Amount of disk space in KB that is logically allocated for long field data in a

table

LOB Objects Amount of disk space in KB that is logically allocated for long field data in a

Field Description

XML Objects Amount of disk space in KB that is logically allocated for XML data in a table

Index Objects Amount of disk space in KB that is logically allocated for the indexes

REORG

Inplace

REORG Status

Current status of an inplace table reorganization on the table The following values are possible:

ABORTED

The inplace table reorganization has status PAUSED but is unable to resume. A STOP is required. For more information, see Utilities:

Inplace Table Reorganization [page 120]. EXECUTING

The inplace table reorganization is currently being executed.

NULL

This value only appears if no inplace reorganization has been performed on the table.

PAUSED

The inplace table reorganization currently pauses and can be resumed again. For more information, see Utilities: Inplace Table

Reorganization [page 120].

REORG Pending

Indicates whether a REORG is pending for the table

This state is possible for ALTER operations like DROP COLUMNthat require an offline reorganization of the table

Number of ALTER Operations

Number of ALTER operations after which a reorganization is required and that have been performed against this table since the last reorganization

Reclaimable MDC Space

For an MDC table in a DMS tablespace, this value indicates the amount of disk space that can be reclaimed by running the REORG command with the RECLAIM option.

For any other table, the value is zero.

Indexes Require Rebuild

Other Technical Attributes

Large RIDs

Indicates if a table is using large row IDs (RIDs) (4-byte page number, 2-byte slot number)

The following values are possible:

YES

The table is using large RIDs.

NO

The table is not using large RIDs.

PENDING

The table supports large RIDs (that is, the table is in a large tablespace) but at least one of the indexes for the table has not yet been reorganized or rebuilt. Therefore, the table is still using 4 byte RIDs, which means that the table or indexes have to be converted.

Large Slots

Indicates whether the table is using large slots (which allows more than 255 rows per page)

The following values are possible:

YES

The table is using large slots.

NO

The table is not using large slots.

PENDING

The table supports large slots (that is, the table resides in a large tablespace) but an offline table reorganization or a table truncation operation has not yet been performed. Therefore, the table is still using a maximum of 255 rows per page.

Blocks Pending Cleanup

Indicates the number of blocks pending cleanup for MDC tables. For tables that do not use MDC, this value is always 0.

Type of Statistics

Indicates how the statistics were generated The following values are possible:

System fabricated

Statistics are gathered by the system without a table or an index scan. These statistics are stored in-memory and are different from the statistics that are stored in the system catalog. This is a temporary state and finally full statistics are gathered by DB2 and are stored in the system catalog.

System asynchronously gathered

Statistics are gathered asynchronously by the system. The statistics have been collected automatically by DB2 by a background process and stored in the system catalogs.

System synchronously gathered

Statistics are gathered synchronously by the system.

User gathered

Statistics are gathered by the user.

Undef

Unknown type of statistics or information that is not available for the current database release

Current Dictionary Size

Current size of compression dictionary in bytes

Index Type

Indicates the type of indexes that are currently in use for the table The following values are possible:

1

Appears if type-1 indexes are being used 2

Availability

Available

Describes the status of the table The following values are possible:

No

The table is not available and all other output information that relates to the size and state is 0.

YES

The table is available.

Note

Rollforward through an unrecoverable load makes a table unavailable. End of the note.

Read Access

Only If the table is read-only, the value is YES. Otherwise, the value is NO. No Load

Restart

The value YES indicates that the table is in partially loaded state that does not allow a load restart. Otherwise, the value NO is returned.

If the table is partitioned or using data partitioning the table status is available for each partition or data partition separately. In this case, an overview list that contains a subset of the information described before, is displayed first. To view the full details, you can select an entry in the list. By default the first entry is displayed.

Note

The physical sizes returned consider full extents allocated for the appropriate object and include the Extent Map Page (EMP) extents for objects created in DMS tablespaces. The logical size is the amount of space that is known for this table. It might be less than the amount of space that is physically allocated to hold object data for the table, for example, in case of a logical table truncation. The logical size returned considers full extents that are logically allocated for the object and, for objects created in DMS tablespaces, an estimate of the EMP extents.