BI_DELETE_OLD_MSG_PARM_DTPTEMP – Cleanup of RSBATCHDATA

rsbatchdata

I am running SAP BW 7.3 (SAPKW73004). I recently noticed that the daily job BI_DELETE_OLD_MSG_PARM_DTPTEMP takes 60000 to 100000 seconds to complete.

Below is the result of the investigation on the issue.

——————–

SAP recommends that a daily job be run to delete old messages and parameters related to running DTPs.

This is part of a large number of recommendations to avoid having table sizes get out of hand (see note Note 706478 – Preventing Basis tables from increasing considerably, see also the list of tables of the note in excel format )
See also recent post in SCN with list of relevant notes.
Table RSBATCHDATA Too Large – How To Delete Data
This cleans up the content of table RSBATCHDATA, that otherwise grows indefinitely.

The BW sap help site recommends running daily with a deletion of messages older than 30 days.  http://help.sap.com/saphelp_nw04s/helpdata/en/48/d2a551003c04e9e10000000a42189c/content.htm

For this you need create a variant for the job to be run with the following parameters

DEL_MSG 30 – delete all records older than nnn day (M-Records)
DEL_PAR 30 – delete all records older than nnn day (R- and P-Records)
DEL_DTP ‘ ‘ – useless/no function (unused parameter as of SAPKW73004, you can see that in the)

(note that not entering parameters or entering 1 or 2 as DEL_MSG/DEL_PAR defaults to deleting records  older than 180 days).

Other terms

RSBATCH, batch manager, RSBATCH_DEL_MSG_PARM_DTPTEMP,
BI_DELETE_OLD_MSG_PARM_DTPTEMP

Leave a Reply