In one of our environments, we have a large amount of records that have been transitioned to the null state. When the cleanup agent runs, it runs out of DB2 transaction log space executing this:
DELETE FROM IBS_SPEC_ASSIGNMENTS WHERE EXISTS (SELECT 'X' FROM IBS_SPEC_CA_DELETE WHERE IBS_SPEC_CA_DELETE.SPEC_ID=IBS_SPEC_ASSIGNMENTS.SPEC_ID)
For Workflow Instance saves, the cleanup agent now seems to remove the data in small chunks (of 1000 rows each) but for the record data cleanup - it still seems to (try to) remove all data in one huge SQL statement/transaction. Is it possible to get the cleanup agent to remove record data in chunks like it does for workflow instance saves?
Otherwise, I'm thinking of writing a small util that would run the statement above but in smaller chunks as it seems we still have the list of record ids that it tries to remove in the IBS_SPEC_CA_DELETE table. Any obvious issues with that?