Show TOC

Procedure documentationChecking/Changing Log Mode Locate this document in the navigation structure

 

Before starting to import transport requests containing SAP content, you should check the currently-set log mode in the database of the SAP Content Server.

The information below relates to the situation in which no log backups are to be performed for the Max DB / SAP DB, but rather the entries are to be overwritten without being backed up first.

Caution Caution

If, in addition to importing the SAP content, you are already using your own materials in the SAP KW, you should perform the log backup.

End of the caution.

Prerequisites

  • You are using the SAP Content Server with the Max DB/SAP DB and have installed and configured it.

  • You want to use the SAP Database Command Line Interface (DBMCLI) to change the log mode of the Max DB/SAP DB.

Procedure

The procedure depends on the database version used for the SAP Content Server. As of SAP DB 7.4.3, the procedure changed (and it is therefore also valid for MaxDB):

For MaxDB/SAP DB (as of Version 7.4.3):

You can change the log mode in operational state ONLINE. The change is effective immediately. If the log area is already full, the change does not become active. In this case, you need to back up the log area first. You can use the following SQL command to check which log mode is set:

Syntax Syntax

  1. SELECT * FROM db_state WHERE description = 'Log automatic overwrite'
End of the code.

To use DBMCLI to change the log mode, enter the following command at a command prompt:

Syntax Syntax

  1. dbmcli -d <database_name> -u <dbm_user>,< password> -uUTL <dbm_user>,<password> util_execute set log auto overwrite on|off
End of the code.

Caution Caution

Also take SAP Note 599445 into account. Pay particular attention to the procedure for switching to standard log mode and the associated backup after completing the desired imports.

End of the caution.
For SAPDB 7.3

To use DBMCLI to change the log mode to DEMO, enter the following command at a command prompt:

Syntax Syntax

  1. dbmcli -u control,control -d SDB -uUTL -c util_execute set log mode demo
End of the code.

Note Note

After all required transport requests have been imported, execute a complete data backup (type: MIGRATION, database status: COLD).

End of the note.