RETIX (Reconstruct Index)

Use the RETIX function to rebuild:
datacom150
Use the RETIX function to rebuild:
  • The data space index for one area or all areas of a database.
  • The data row count for one area or all areas of a database.
  • The Transaction Sequence Number (TSN) for one area or all areas of a database.
  • The Index Area (IXX) for one or all data areas of a database. 
  • The data High Used Mark for one or all areas of a database.
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.