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 stores7

The following command changes the logging mode of a database to ANSI-compliant logging:

ontape -s -L 0 -A stores7

The following command changes the logging mode of a database to unlogged:

ontape -N stores7