Change database logging status
You can use the ontape utility to change the logging status of a database. Most changes in logging mode require a full level-0 backup.
You cannot change the logging mode of an ANSI-compliant database.
You can change an unbuffered logged or buffered logged database to an unlogged database without making a backup.
You can make the following logging modes changes with a level-0 backup:
- An unbuffered logged or buffered logged database to an ANSI database
- An unbuffered logged database to a buffered logged database
- A buffered logged database to an unbuffered logged database
Examples
The following command changes the logging mode of a database named stores7 to unbuffered logging:
ontape -s -L 0 -U stores7The following command changes the logging mode of a database to ANSI-compliant logging:
ontape -s -L 0 -A stores7The following command changes the logging mode of a database to unlogged:
ontape -N stores7