Search code examples
db2database-backupsdb2-luwdatabase-restoreroll-forward

Db2 rollforward "to end of backup" vs. "to end of logs"?

On Db2 Enterpise Server Edition v11.1 single patitioned database on Linux/Intel using LOGARCHMETH1 I executed backup and restore commands:

db2 "backup database mydb online to /path/to/backup include logs without prompting"

Then on identical Linux/Db2 computer:

db2 "restore database mydb from /path/to/backup into mydb logtarget /path/to/logs"

What is the difference between "end of backup" and "end of logs"?

db2 "rollforward database mydb to end of backup and stop overflow log path (/path/to/logs)"

db2 "rollforward database mydb to end of logs and stop overflow log path (/path/to/logs)"

Regards

Solution

  • to end of backup and stop: it will apply only the transaction logs backuped during the online backup (it will apply only the log generated during the backup to have a coherent database).

    to end of logs and stop: will apply all transaction log that it find