Registration

Dear SAP Community Member,
In order to fully benefit from what the SAP Community has to offer, please register at:
http://scn.sap.com
Thank you,
The SAP Community team.
Skip to end of metadata
Go to start of metadata

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.