Database Tools

Use the Database Tools page to run data maintenance operations. It is recommended that you use these functions only when directed to do so by IBM Support.

You can run the following operations on the database:

Clear Inventory Data

When you clear the inventory database, all the inventory data that is collected from the endpoints is deleted, but the configuration data (like Scope sets, Scopes, and Credentials) is retained.

To clear the inventory data, complete the following steps:
  1. In the navigation pane, click Tools > DB Tools. The Database Tools page is displayed.
    Figure 1. Database Tools
    Database Tools
  2. Click Clear Inventory Data. The following warning message is displayed - Taking this action will temporarily shutdown the Discovery Manager. Are you sure you want to clear the inventory data?
    Note: Do not clear the inventory data unless recommended by the IBM Support team.
  3. Click Accept to clear the inventory data. The following message is displayed - Clear Inventory Data Started. It might take some time to clear the inventory data based on the number of endpoints that have been discovered. After the inventory data is successfully cleared, you can check the Activity Log to view the status as Clear Inventory Data successful.

Performing RUNSTATS

To run the RUNSTATS command, complete the following steps:
  1. In the navigation pane, click Tools > DB Tools.
  2. Click Perform RUNSTATS. The following warning message is displayed - Are you sure you want to perform RUNSTATS on the inventory database tables?
  3. Click OK. The following message is displayed - RUNSTATS Started. After approximately 30 minutes, you can check the activity log. When the job is complete, the following message is added to the activity log - RUNSTATS for inventory database successful.

Performing REORG

To run the REORG command, complete the following steps:
  1. In the navigation pane, click Tools > DB Tools.
  2. Click Perform REORG. The following confirmation message is displayed - Are you sure you want to perform REORG on the inventory database tables?
  3. Click OK. The following message is added to the activity log - REORG Started. After approximately 30 minutes, you can check the activity log. When the job is complete, the following message is added to the activity log - REORG inventory database successful.