SAP Note 23851 - SAPF040: Problem with ROLLBACK segments

Symptom:

ROLLBACK segments overflow during deletion of large datasets.
Key words: SAPF040 SAPF040D F040

Cause and prerequisites

a) Offline redo logs overflow (database archiving)
b) Online redo logs overflow

Solution

If case a) has occurred, either

• Split up the documents to reduce the quantity for archiving in a single run

• and/or deactivate the writing of offline redo logs

• and/or provide more disk space for the offline redo logs
  

If case b) has occurred, either

• Provide more disk space for the online redo logs (recommended)

• Reduce the COMMIT counter for deletion
  

To implement the latter:

Release 2.1 or 2.2, change program SAPF040D:
...
*
* Systemvariablen
*
"DATA: MAX_DEL TYPE I VALUE 5000, "<<<---- delete
"DATA: MAX_DEL TYPE I VALUE 1000, "<<<---- insert
X_CLUSTER TYPE C VALUE 'X'. "Löschen des Belegs im Cluster
*
INCLUDE F040TOP .
*
...

Starting in Release 3.0A: The COMMIT counter can be maintained in Customizing for archiving object "FI_DOCUMNT" using transaction SAR3.