What transaction logs does DB2 use at the end of a restore?
adamsand 2000003VK2 Comment (1) Visits (7322)
Answer: "It depends" :-) This question came up again recently, so I thought I might do a short post on it.
An offline backup does not require any logs at the end of the a restore but you can still apply them if you leave off the "WITHOUT ROLLING FORWARD" syntax. The "WITHOUT ROLLING FORWARD" syntax only applies to the restore of an offline backup and will generate a warning if you try to use it during the restore of an online backup. Of course, the restore of an online backup needs, at a minimum the logs, that spanned the backup to complete a rollforward to the MRT (Minimum Recovery Time - i.e. "END OF BACKUP").
Please leave a comment if you have any questions or feedback.