Skip to Content
0
Jan 11, 2012 at 06:56 PM

Database space not getting freed after deletion jobs in PI 7.0

70 Views

Hi Experts,

I have a <Removed by moderator> requirement in my project to release database space from PI server.

I have done the following things to accomplish this:

1. Set the retention period in SXMB_ADM

2. Activated "Switch delete procedure" in SXMB_ADM.

3. Scheduled the Deletion job and History Deletion jobs in PI. This job is running successfully and the joblog states that the entries are being deleted.

The messages are getting deleted from SXMB_MONI,but the DB space is not getting freed.

Also the entries in SXMS* tables is not getting deleted.

Please suggest a solution as almost 92% space of our current production system is already occupied.

Thanks,

Nitin Nigam

Edited by: Prateek Raj Srivastava on Jan 12, 2012 1:08 AM