Problem
Table RSBATCHDATA has grown too large. You want to delete data from table RSBATCHDATA to reduce its size.
Solution
1) First ensure that all of the Notes below are in the system. Depending the current system Support Package level not all of the Notes may need to be applied. Systems higher than the levels below will not need to apply the Notes:
SAP BW 700 | SP 30 |
SAP BW 701 | SP 13 |
SAP BW 702 | SP 13 |
SAP BW 711 | SP 11 |
SAP BW 730 | SP 09 |
SAP BW 731 | SP 06 |
Note Number | Note Title |
---|---|
P17:RSBATCH_DEL_MSG_PARM_DTPTEMP does not delete all record | |
P21: BATCH: Performance prob. in RSBATCH_DEL_MSG_PARM_DTPTEMP | |
P21:No entry in TS field of table RSBATCHDELDATA | |
P21:RSBATCH_DEL_MSG_PARM_DTPTEMP runs for a very long time | |
P23:BATCH:Slow select/delete accesses to table RSBA | |
P25:RSBATCH_DEL_MSG_PARM_DTPTEMP:Timestamp increase | |
P28:RSBATCH_DEL_MSG_PARM_DTPTEMP:Also delete RSBATC | |
P29:BATCH:RSBATCH_DEL_MSG_PARM_DTPTEMP no longer de | |
P29:RSBATCH:RSBATCH_DEL_MSG_PARM_DTPTEMP does not d | |
P30:BATCH:Löschen aus RSBATCHSTACK dauert lange; Pe |
2) Next schedule program RSBATCH_DEL_MSG_PARM_DTPTEMP to delete data from table RSBATCHDATA.
In this example all Messages and Parameters older than 90 will be deleted but you can choose any value.
3) Also follow this help document 'Deleting Messages and Parameters from BW Background Management' to reduce the size of Table RSBATCHDATA.
http://help.sap.com/saphelp_nw73ehp1/helpdata/en/48/d2a551003c04e9e10000000a42189c/frameset.htm
Following the steps above should see a noticable reduction in the size of Table RSBATCHDATA.