RETIX (Reconstruct Index)

RETIX (Reconstruct Index)

Use the RETIX function to rebuild:

• The data space index for one area or all areas of a database (see the following information).
• The data row count for one area or all areas of a database (see the following information).
• The Transaction Sequence Number (TSN) for one area or all areas of a database (see the following information).
• The Index Area (IXX) for one or all data areas of a database. (See Rebuilding an Index Area.)

The RETIX function of DBUTLTY reads the data area in a physical sequence to rebuild an Index Area.

You can also use the RETIX function to reset the Transaction Sequence Number (TSN). (See Resetting the TSN.)

See COMM STATUS (Print Status of MUF Jobs) for information about DBUTLTY STATUS console command support for this function.

For information about dynamic extend considerations with regard to this function, see DBUTLTY Dynamic Extend Considerations, and for information about the DYNAMIC_EXTEND console-like command, see the CA Datacom/DB Database and System Administration Guide.