Logging Mode with SAPDBA
Logging Mode with SAPDBA
Use
You can use SAPDBA for Informix to change the logging mode of the Informix database server. This is easier and more secure than using the Informix tools. It is easier because you do not have to manually enter Informix commands. It is more secure because SAPDBA only lets you choose between the allowable logging modes for use with the R/3 System, so avoiding selection of an incorrect logging mode.
Do not run the database in "no logging mode" except for essential maintenance. Otherwise you will not be able to restore the database in the event of failure.
Integration
If the logging mode is incorrect (that is, no logging mode), an alert is raised in the Release 4 alert monitor in the Computing Center Management System (CCMS) of the R/3 System. For more information, see
Monitoring the Database with the Release 4 Alert Monitor (Informix).
Features
These actions enable you to alter the logging mode of the database, as follows:
This means that database transactions are written to the logical log. You must use this setting for normal productive database operation.
This means that database transactions are not written to the logical log. You use this setting for essential database maintenance, such as reorganizations.
Activities
Choose the action you require from the following:
If you want to check the current logging mode of the database, SAPDBA displays this logging mode on all menu screens.
See also:
Informix documentation