38 DB2 Recovery Expert for Multiplatforms
To make log file administration easier, you can configure DB2 to automatically
“archive” the archived log files to a location other than the log path using a
“userexit” program. Refer to “Appendix C” of DB2 UDB Administration Guide:
Implementation, SC09-2944, for details of how to do this.
An advantage of using a USEREXIT to archive your logs is that, if the database is
accidentally dropped, the logs will not be deleted. They will still exist in the
archive location, allowing you to restore from a backup and roll forward.
3.5.4 DROPPED TABLE RECOVERY (optional)
The DROPPED TABLE RECOVERY table space option allows dropped tables in
that table space to be recovered. However, recovery using this method ...