Home | Previous Page | Next Page   Logging and Log Administration > Managing the Database-Logging Mode > Modifying the Database-Logging Mode with ondblog >

Changing the Logging Mode of an ANSI-Compliant Database

After you create or convert a database to ANSI mode, you cannot easily change it to any other logging mode. If you accidentally convert a database to ANSI mode, follow these steps to change the logging mode:

To change the logging mode
  1. To unload the data, use dbexport or any other migration utility. The dbexport utility creates the schema file.

    For information about how to load and unload data, see the IBM Informix Migration Guide.

  2. To re-create a database with buffered logging and load the data, use the dbimport -l buffered command.

    To re-create a database with unbuffered logging and load the data, use the dbimport -l command.

Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]