Optimizing database with Configuration Tool

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

Before you begin

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

A directory server instance that is configured with a DB2 database must exist. See Configuring a database for an instance with Configuration Tool.

Start Configuration Tool for an instance.
See Starting Configuration Tool.
From the task list in the left navigational pane, click Database tasks > Optimize database.
In the Optimize database page, complete the following steps:
1. To start the database optimization operation, click Optimize.
2. To accept task completion, click OK.
3. Verify the logs that are generated for the database optimization operation.
4. To clear the logs, click Clear results.
To close the Optimize database page, click Close.
To close the Configuration Tool window, click File > Exit.
To confirm your action, click Yes.