Previous Topic: Sample Report:  DBIDPPRNext Topic: Overview


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) then doing a RETIX or LOAD of the DBID.

In order to INIT the IXX, the DBID must be completely offline to other users. The DEFRAG function runs through the Multi-User Facility and allows the DBID to remain online and usable to other applications during the DEFRAG.