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.
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.