DEFRAG (Defragment Index)

The DBUTLTY DEFRAG function defragments or compresses the DXX, that is, the "lowest" level of the IXX that contains key values and pointers to actual rows. The DBUTLTY DEFRAG function provides a simpler way to accomplish much the same results as performing an INIT to the Index Area (IXX) and then doing a RETIX or LOAD of the DBID.

For the INIT function to operate on the IXX, the DBID must be completely offline to other users. However, the DEFRAG function runs through the MUF and allows the DBID to remain online and usable to other applications during the DEFRAG process.