Cleaning up or deleting the Document Processing databases

If you want to delete Document Processing projects that you no longer need, you can use scripts to clean up or delete the databases.

Procedure

  1. In Business Automation Studio, in Automations, delete the project. This action marks the status of the underlying database as not being used, and ready for either reinitialization (clean up) or deletion.
  2. Log in to the Db2® server, and navigate to the directory containing the cert-kubernetes folder that you created as part of the installation preparation.
  3. Go to the ACA/configuration-ha/DB2 subfolder.
  4. Run a script to either clean up or delete the project databases.
    1. To clean up the database, run the following script:
      ProjectCleanup.sh
      or if you are on Windows:
      ProjectCleanup.bat
    2. To delete the database, run the following script:
      ProjectDelete.sh
      or if you are on Windows:
      ProjectDelete.bat
  5. When prompted, provide the name of the Base database.
  6. When prompted, provide the name of the database user for the Base database.
  7. If there are no databases marked for reinitialization or deletion, the script does not perform any action.
  8. If there are multiple databases marked for reinitialization, the script attempts to reinitialize each database with the default data.

    If there are multiple databases marked for deletion, the script attempts to permanently remove each database.

  9. If you ran the ProjectCleanup script: After being reinitialized, the database(s) are ready be to used for new project(s), as needed.