Customer wants to completely delete and recreate the Archive DB.
14.4
To delete and recreate archive DB, we need to use the OOTB scripts.
Please make sure to take backup first your DB and run the scripts in the lower environment and verify thoroughly.
Please be extremely cautious when running these scripts. Review with your DBA all backups and snapshots are valid and to verify all the objects were removed properly.
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