IBM Support

Support's policy on deleting the records manually instead of running the Purge

Question & Answer


Question

Support's policy on deleting the records manually instead of running the Purge

Answer

Support is getting requests from various customers to delete the records manually instead of running the purge. The reason being:

1) Customer might not have started the purge after their go live and the number of records in the table grow up to millions.

2) Because of the huge number of records in the tables, they may see performance issues.

Support's policy:

Support does not recommend running any queries to delete the data from the tables if the purge is available. Deleting the data from the table thru script may cause data integrity issues. To further add, you can initially run the purge with retention days as higher number and change it to "lower" at later time. Say for ex: start with purging data more than120 days and then move to 90, 60, 30 respectively. This will ensure that number of eligible records to be purged will be less and will not cause any performance impact.

[{"Product":{"code":"SS6PEW","label":"IBM Sterling Order Management"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Not Applicable","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}},{"Product":{"code":"SS6PEW","label":"IBM Sterling Order Management"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Not Applicable","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Historical Number

FAQ4352

Document Information

Modified date:
16 June 2018

UID

swg21519851

Page Feedback