ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Identity Manager - How to Cleanup Archive Database

book

Article ID: 132537

calendar_today

Updated On:

Products

CA Identity Manager CA Identity Governance CA Identity Portal

Issue/Introduction

When you are Cleaning up the Task Persistence Database using the Archive feature, after some time the Archive Database will need maintenance.
For this we have provided a readme file with instructions how to use a Stored Procedure to perform the cleanup of Archive tables.
 

Environment

Identity Manager 12.6.x
Identity Manager 14.x
Virtual Appliance and On-Premise versions

Resolution

Readme file is included in the Admin Tools package:

vApp - 14.x till 14.3, the location is under folder:
/opt/CA/IdentityManager/IAM_Suite/IdentityManager/tools/db/taskpersistence

For vApp 14.4 /  on-premise version, the location is that of the Admin Tools:
X:\...\CA\Identity Manager\IAM Suite\Identity Manager\tools\db\taskpersistence