Configuring database logging
Normally, new databases are created by default with circular logging. However, their sole means of backup is an offline backup. This is fine for many types of use, but you may prefer to have other backup options.
Many backup solutions rely on archive logging. We have seen briefly in Chapter 2, Administration and Configuration of the DB2 Non-partitioned Database, how we can configure the database for automatic online backups and change the database logging method.
We will see here how to switch from a circular logging method to an archive logging mode. This will be used, as you will see in Chapter 8, DB2 High Availability, to set up high availability with log shipping, or anytime you may decide to switch from offline to online backups.
Getting ready
You will have to clear any sessions accessing the database. Allow for downtime and space for a full backup of the database, and allow a place to store archive logs.
How to do it...
Quiesce the database:
As instance owner...
