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

This section should help you to shorten the backup history of SAP MaxDB/liveCache databases manually as there is not yet a automatic feature for this.

Symptom

When you use transactions DBACOCKPIT, DB50, LC10, DB14, the Database Studio or Database Manager CLI (DBMCLI) to display the backup history, the system requires a long time for this process or the following or similar errors may occur:  (6: overflow)

Reason and Prerequisites

The backup history of a database that is based on SAP MaxDB (for example, SAP liveCache, SAP Content Server, OneDB and so on) is stored in the files dbm.knl and dbm.mdf in the im run directory (usually, /sapdb/data/wrk/<SID>).
These files are always enhanced at the file end so that the files get larger as the number of backup operations or restore operations increases.
Since the files include the information even of backups that are no longer significant (for example, because the backup medium has been overwritten in the backup cycle in the meantime), the backup history contains an increasing amount of insignificant data.

Solution

The solution is described in SAP note 1089402 Reducing the backup history for the SAP MaxDB/liveCache database.

back to top

  • No labels