Skip to Content
0
Sep 16, 2015 at 07:41 PM

Cleanup old deleted assignments and save DB space ?

295 Views

Hi Experts,

Would anyone share experience how to cleanup old privilege assignments from IDM 7.2 database and save disk space ?

In our database we accumulated a huge amount of old assignments (links) in a deleted state. The MXI_LINK table consumes lots of disk space and contains millions of records. Mostly these links are in the deleted state (mcLinkState = 2) and, therefore, are excluded from any processing by IDM and not visible in idmv_link_ext view and similar ones.

I'm considering deletion of all MXI_LINK records with mcLinkState = 2. Is there any pitfall or issues with such cleanup ? The IDM Operations guide states to cleanup IDM historical data periodically, but the cleanup of old links is not mentioned there.

Any thoughts or idea ? Please share them here.

Thanks a lot!

Siarhei