sobota, 25. julij 2015

Bring database out of BACKUP PENDING state ASAP

If you manage to put your database into BACKUP PENDING state and want to bring it out of it ASAP you can do a backup to a NULL device:
db2 backup db MYDB to /dev/null
The backup will still read the data that should go into the backup image, but it will discard it by writing it into NULL device. In this way you can cut the unwanted downtime by about 50%-60%.