Considerations for DB2 Online backup and offline backup

The difference between DB2 online backup and offline backup

1 The general default to establish a DB2 database is not supported online backup (in the DB2 Control center)

If you want a DB2 database to support Online backup, update db CFG for sampledb using Logretain=on serexit=on,trackmode=on

2 If a DB2 database supports both online and offline backups, be careful when backing up, and if you want to do an online backup, you must copy the logs separately. Otherwise, it cannot be rolled back and cannot be used.

(Of course, if it's done on the same machine, there is no need to handcuff, in the recovery after the rollback, directly assigned to the source database log path can be, but also pay attention to time constraints, a long time, in the online backup point of time that the log may be covered by a new log file and does not exist.

(This, SQL Server is better, online backup directly to the log file and database body into a file, without the need for a separate copy), if it is offline backup, you do not need.

3 offline backup after recovery, plus the parameter without rollforward ...

4 After online backup, must rollforward to ....

5 Force Application Stop command is actually not related to offline backup/online backup.

------------------------------------------------

To this end, let the customer back up, she got an online backup, but no log, the result is hurt to go back to the customer there ran a trip .... Miserable.