Database maintenance

To improve search or update operations against an instance, you can run DB2® index reorganization or DB2 row compression.

You can use Configuration Tool or the idsdbmaint command to run DB2 index reorganization or DB2 row compression.

When the DB2 tables of a database are updated with many insertions and deletions, search and update operations against the database become slower. If you reorganize the DB2 index, the performance of the search and update operations improves.

When you run DB2 row compression, the tool searches for repeating patterns and replaces them with shorter symbol strings. The tool analyzes and then runs the row compression only if the compression results in an improvement of greater than 30 percent.

For more information about the idsdbmaint command, see Command Reference.