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 recreate a database with buffered logging and load the data, use the dbimport -l buffered command.

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