Backup and recovery enhancements
Db2 12 introduces enhancements to the BACKUP and RECOVERY utilities.
Db2 12 introduces the following improvements to the BACKUP and RECOVERY utilities:
- Point-in-time (PIT) recovery support for PBG table spaces
- You can recover PBG table spaces to a PIT prior to a REORG that materialized these physical pending alters: page size (buffer pool) DSSIZE, SEGSIZE, member cluster.
- FLASHCOPY_PPRCP keyword
- You can specify the FLASHCOPY_PPRCP keyword for the RESTORE SYSTEM and RECOVER utilities, to specify or override the preserve mirror option for PPRC (sync disk mirroring) on the utility statement.
- New default behavior for the PIT RECOVER utility
- Point-in-time recovery is skipped for non-updated pagesets, which saves resources (CPU) and time.
- System Level Backup support for multiple copypools
- You can keep extra system-level backups on disk during upgrades.
- Improved messaging for BACKUP SYSTEM and RESTORE SYSTEM
- DFSMShsm messages included in the utility job output for BACKUP SYSTEM and RESTORE SYSTEM provide improved messaging.
- COPY option to specify FASTREPLICATION(REQUIRED)
- You can control whether FlashCopy® is required during creation of the FlashCopy image copy.
- New MODIFY RECOVERY option DELETEDS
- You can use this to delete image copy data sets.
- New MODIFY RECOVERY option NOCOPYPEND
- You can use this to specify that MODIFY RECOVERY not set COPY pending.
- More accurate validation of recovery scenarios
- When you execute MODIFY RECOVERY at the table space level a SYSCOPY record for each partition is inserted, which allows a more accurate validation of recovery scenarios.