on 03-31-2009 10:44 AM
Hello
The tables SWW_*, SWWWIHEAD, SWWLOGHIST, SWPNODELOG, SWPSTEPLOG are growing rapidly in our system, totalling over 100 GB. We are considering archiving/deleting old work items, i.e. older than three months that are in status completed.
What are the risks in terms of data integrity / auditability when deleting these logs, in other words, do we have to archive the old work items or can we simply dleete them?
Thanks
Wilhelm
Hi Wilhelm,
It is generally recommended to archive workitems than to delete.
Refer Note 573656.
Thanks,
Naveen
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Check the T.code SARA.
Refer [Link|https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/3643cdbb-0601-0010-c89d-c069bc395909].
Regards,
Surjith
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
My suggestion is better archive the workitems rather than deleting them , make use of the FM WORKITEM_ARCHIVE_OBJECT and read the documentation provided by SAP in SE37
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
78 | |
10 | |
7 | |
6 | |
6 | |
6 | |
6 | |
6 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.