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

Switching to "Unbuffered Logging Mode" with SAPDBA

Use

You can use this action in SAPDBA to put the Informix database into "unbuffered logging mode". In this mode, database transactions are written to the logical log. In normal productive database operation, you must use this mode. For more information, see Logging Mode with SAPDBA.

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 this switch is possible. SAPDBA warns you if users are still connected when you start the switch.

Procedure

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

Result

The database is now in unbuffered logging mode. You can now use the database safely for production.

Caution

As soon as you switch 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