Changing the logging mode of an ANSI-compliant database
About this task
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:
Procedure
- 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 Informix® Migration Guide.
- 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.