Switching to "No Logging Mode" with SAPDBA (SAP Library - SAP Database Guide: Informix (BC-DB-INF-DBA))"No Logging Mode" with SAPDBA

Switching to "No Logging Mode" with SAPDBA

Use

You can use this action in SAPDBA to put the Informix database into "no logging mode." In no logging mode, database transactions are not written to the logical log. For more information, see Logging Mode with SAPDBA.

Caution

Do not run your database in no logging mode except for essential maintenance. If you use no logging mode for productive database operation, you cannot restore the database following a failure.

Prerequisites

SAPDBA is installed correctly. Refer to SAPDBA Setup.

You know how to use SAPDBA and have logged on. Refer to Starting SAPDBA.

All users must be disconnected from the database before a switch to no logging mode is possible. SAPDBA warns you if users are still connected when you start the switch.

Procedure

Choose Logging Mode → Switch to 'No Logging Mode' in SAPDBA.

Result

The database is now in no logging mode. Do not now use the database for production.

Caution

As soon as you switch back to unbuffered logging mode, you must do a level-0 database archive or backup. Refer to Database Backup (ON-Bar) or Archive (ON-Archive and ontape). Without this, you can not restore transactions executed after you switch back to unbuffered logging mode.

See also:

Informix documentation