Table RSBATCHDATA Too Large - How To Delete Data

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
1132513	P17:RSBATCH_DEL_MSG_PARM_DTPTEMP does not delete all record
1292051	P21: BATCH: Performance prob. in RSBATCH_DEL_MSG_PARM_DTPTEMP
1320042	P21:No entry in TS field of table RSBATCHDELDATA
1269088	P21:RSBATCH_DEL_MSG_PARM_DTPTEMP runs for a very long time
1372843	P23:BATCH:Slow select/delete accesses to table RSBA
1504034	P25:RSBATCH_DEL_MSG_PARM_DTPTEMP:Timestamp increase
1644086	P28:RSBATCH_DEL_MSG_PARM_DTPTEMP:Also delete RSBATC
1708184	P29:BATCH:RSBATCH_DEL_MSG_PARM_DTPTEMP no longer de
1657186	P29:RSBATCH:RSBATCH_DEL_MSG_PARM_DTPTEMP does not d
1775552	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.