Cleanup of Unnecessary Work items
In our production system, we have table SWPNODELOG of size 236 GB & its growing rapidly. We checked few snotes for housekeeping of unnecessary work items from system.
one of them was snote 49545, where its mentioned to use reports for deletion through reports RSWWWIDE and RSWWHIDE, also found snote 573656, where it is mentioned, It is NOT recommended you use report RSWWWIDE in a production system.
So, we are confused, what is best approach in terms of removing unwanted work items from system,to go with archiving or deletion with specific variant (like older than X days).
Also, in case, if our customer don't want to go with archiving, can we go with deletion approach, what are disadvantages of this ?
Pls provide your valuable response on this topic.