Running database maintenance with Configuration Tool

Edit online

Use Configuration Tool to maintain the DB2® database that is associated with an instance.

Before you begin

To maintain the DB2 database for an instance, the instance must meet the following requirements:

Procedure

  1. Start Configuration Tool for an instance.
    See Starting Configuration Tool.
  2. From the task list in the left navigational pane, click Database tasks > Maintenance .
  3. In the Maintenance page, complete the following steps:
    1. Select the DB2 database maintenance operation that you want to run:
      • To run DB2 index reorganization, click Perform index reorganization.
      • To run DB2 row compression, click Inspect the tables and perform row compression.
    2. Click OK.
    3. In the task completion window, click OK.
    4. Verify the logs that are generated for the database maintenance operation.
    5. To clear the logs, click Clear results.
  4. To close the Maintenance page, click Close.
  5. To close the Configuration Tool window, click File > Exit.
  6. To confirm your action, click Yes.

What to do next

Start the directory server. See Starting or stopping a directory server and an administration server with Configuration Tool.