Backup and recovery in DB2 pureScale environments
In essence, the methods used for backup and recovery are not that different from non-pureScale systems, excluding a multipartitioned database, which is a different subject. Backup and recovery in a pureScale environment can be conducted from any member. The commands used are the same as those found in non-pureScale setups.
Getting ready
In this recipe, we will perform an offline backup, followed by an online backup. Next, we will perform a restore and recovery in roll-forward mode, followed by a conventional database recovery.
How to do it…
Performing a pureScale database backup and recovery is similar to a normal database backup, with some slight differences, such as, for offline backups, all members must be consistent before performing a backup.
Performing an offline database backup
Prepare the database to be eligible for online backups. Configure the archive log location, number of primary logs, secondary logs, and log file size, by using the...
