Hi,

We need to release space in Pega DB as it has reached 90% of utilization. I am thinking of using below queries to carry out hard delete instead of using OOTB Purge and archive wizard as this process will take time (In one of the article, I red that number records for deletion should be less, not even 5000 else purging may fail). We need to clean up the space asap.

delete from pc_data_uniqueid update pc_data_uniqueid set pylastreservedid=0 //To reset the work object ID numbering sequence delete from <Application Work pool associated database table name> delete from pc_work delete from pc_assign_worklist delete from pc_assign_workbasket delete from pc_history_work delete from pc_data_workattach delete from pc_index_workparty delete from pc_link_attachment delete from pc_link_folder

I have following queries.

1. Is there any issue if we use above queries (I will add where clause to take care of retention period)?

2. If required, can we reinstate data for these tables OR do we need to take backup before running above queries? As per my understanding, we have point in time reinstate strategy