DB2 index reorganization

Edit online

You can run DB2® index reorganization on a directory server to eliminate fragmented data in the database table and to restructure the index data. You must run the DB2 index reorganization operation on the directory server instance with the instance owner credentials.

When you run the idsdbmaint command to initiate DB2 index reorganization, the following operations are run:

Queries DB2 sysibm.sysindexes on the tables of the directory server instance, and then fetches all the tables for which indexes are defined.
Runs index reorganization on all the indexes.
Updates the table statistics after index reorganization is run on the table.

To optimize the database, you can run the idsdbmaint command with the index reorganization parameter. For example:

idsdbmaint -I instance_name -i