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 HCL
OneDB™
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.