Reorganizing an index on the DB2 Server for VSE & VM

Use the Reorganize Index window to reorganize an index for the DB2 Server for VSE & VM.

Use the Percentage dialog to display the percentage of free space to be left on index pages.

When an index is reorganized, free space is reserved in the index for later insertions and updates.

Fields and controls

Authorities and privileges



To reorganize an index on the DB2 Server for VSE & VM:

  1. Open the Reorganize Index window.
  2. Set the percentage of free space to be left on index pages or use the existing setting.
  3. Click OK to reorganize the selected index.

Note: the Reorganize option will only be able to reorganize indexes maintained in DB2 Server for VSE & VM release 6.1.0 or later. The stored procedure, ARISCCF, must be configured and available to support the reorganize index function.

Related information