Scripts to delete and recreate the Archive DB

Products

• CA Identity Suite

Issue/Introduction

Customer wants to completely delete and recreate the Archive DB.

Environment

14.4

Cause

To delete and recreate archive DB, we need to use the OOTB scripts.

Resolution

Use the below out-of-the-box scripts, to delete and recreate archive DB.

Scripts are located in the Tools directory as follows:
/opt/CA/IdentityManager/IAM_Suite/IdentityManager/tools/db/taskpersistence/

For example, if the customer has sqlserver database then
Script for deleting archive tables: archive_db_sqlserver_delete.sql
Script for recreating archive tables: archive_db_sqlserver.sql

If the customer has oracle database then
Script for deleting archive tables: archive_db_oracle_delete.sql
Script for recreating archive tables: archive_db_oracle.sql

Please make sure to take back up of old archive DB and run the scripts in the lower environment and verify thoroughly.

Please be extremely cautious and take help from DBA to run the delete script and verify if all the objects were removed properly (run another time if objects are not removed properly) before running the create script otherwise it will lead to issues.

If everything goes well, then please implement it in production.