1022 + 2 MB Memory

Take an OFFLINE backup db2 connect to db2 quiesce database immediate force connections db2 connect reset db2 backup database to compress without prompting after backup completes: db2 connect to db2 unquiesce database db2 connect reset Take an ONLINE Backup db2 backup db to online compress or use a background process on a linux/unix machine nohup db2 backup db to online compress & List recent backups and where they are stored =>db2 list history backup all for Check the integrity of a backup image =>db2ckbkp Restore from Incremental Backup Automatic =>db2 restore db incremental automatic taken at If you need to restore an incremental backup manually this command will give you the required previous backups. =>db2ckrst -d -t

The following notes are for myself only. Whoever happened to accidentally read these notes, please do not ask any question. SQL2413N Online backup is not allowed because the database is not recoverable or a backup pending condition is in effect. Explanation Online backup cannot be performed while the database is not logging for forward recovery as forward recovery will be required at restore time. Forward recovery is placed into effect by setting either the database configuration LOGARCHMETH1 or LOGARCHMETH2 and then performing an offline backup of the database. User response Execute an offline backup or reconfigure the database for roll-forward recovery and issue an offline backup so that subsequent online backups will be allowed. ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ The operation failed because the specified database cannot be connected to in the mode requested.  SQLSTATE=57019 Resolving the problem The issue can be addressed by using th