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

Making a Database ANSI Compliant with ontape

To make a database called stores_demo, which already uses transaction logging (either unbuffered or buffered), into an ANSI-compliant database with ontape, execute the following command:

ontape -A stores_demo

To make a database called stores_demo, which does not already use transaction logging, into an ANSI-compliant database with ontape, execute the following command:

ontape -s -A stores_demo

In addition to making a database ANSI compliant, this command also creates a storage-space backup at the same time. Specify a level-0 backup when you are prompted for a level.

Tip:
After you change the logging mode to ANSI compliant, you cannot easily change it again. To change the logging mode of ANSI-compliant databases, unload the data, re-create the database with the new logging mode, and reload the data. For details, see Changing the Logging Mode of an ANSI-Compliant Database.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]