Cleaning up monitor data for deleted connections

You can clean up monitor data for deleted database connections.

About this task

When you add a database connection with the Data collection credential that is turned on, the console collects the monitor data. But when you delete the database connection, the related monitor data is not removed or cleaned up in the repository tables.

Procedure

To clean up monitor data for deleted connections:

  1. Copy the script to where repository database is located.
    Linux® and Unix: 
    setup_directory/ibm-datamgmtconsole/dsutil/bin/deleteRepoData4DeletedConnection.sh
    Windows:
    setup_directory/ibm-datamgmtconsole/dsutil/bin/deleteRepoData4DeletedConnection.bat
  2. Edit the script and configure parameters:
    • repodb- specify the name of repository database.
    • schema- specify the name of schema that was used when you configured the repository database. IBMCONSOLE is the default schema.
    • size- specify the number of records to be deleted in each cycle. Default size, is 512.
  3. From the command line, run the script.