Running database maintenance with the command-line utility

Edit online

Use the command-line utility, idsdbmaint, to run maintenance operation on the DB2® database that is associated with an instance.

Before you begin

To run the DB2 database maintenance operation, the instance must meet the following requirements:

Procedure

  1. Log in as directory server instance owner.
  2. Access the command prompt.
  3. Change the current working directory to the sbin subdirectory in the IBM® Security Verify Directory installation location.
  4. To run DB2 index reorganization, run the idsdbmaint command in the following format:
    idsdbmaint -I instance_name -i
    For more information about the idsdbmaint command, see Command Reference.
  5. To run DB2 row compression, run the idsdbmaint command in the following format: 
    idsdbmaint -I instance_name -r

What to do next

Start the directory server. See Starting or stopping a directory server and an administration server with command-line utilities.