In This Chapter

This chapter covers the following topics on changing the database-logging mode:

• Understanding database-logging mode
• Modifying database-logging mode with ondblog
• Modifying database-logging mode with ontape
• Modifying database-logging mode with ON–Monitor
• Monitoring transaction logging

As a database server administrator, you can alter the logging mode of a database as follows:

• Change transaction logging from buffered to unbuffered.
• Change transaction logging from unbuffered to buffered.
• Make a database ANSI compliant.
• Add transaction logging (buffered or unbuffered) to a database.
• End transaction logging for a database.

For information about database-logging mode, when to use transaction logging, and when to buffer transaction logging, see Logging. To find out the current logging mode of a database, see Monitoring the Logging Mode of a Database.