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, 14.5

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:

1. Log in to support.broadcom.com.
2. Select Cyber Security Software from the drop-down list that is displayed beside your account name in the header.
3. Click My Downloads in the left pane.
4. Search for and select IDENTITY MGMT AND GOVRNCE.
5. In the Products tab, select a product. For example, IGA for Business Users MULTI-PLATFORM.
6. Select the desired version - 14.5.
7. Download the Symantec IGA Virtual Appliance Remote Tools r14.5 zip file using HTTP or FTP.

8. Unzip the Symantec IGA Virtual Appliance Remote Tools r14.5 zip

9. Unzip the file CA-IM_Tools.zip inside of folder Symantec IGA Virtual Appliance Remote Tools r14.5.

10. Navigate to 
Symantec IGA Virtual Appliance Remote Tools r14.5\CA-IM_Tools\CA-IM_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