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

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