I am currently running DB2 8.1.5 Workgroup Server Unlimited Edition. I have a small problem. I do weekly online backups of my DB but now the log files have reached over 5 GB and that is taking up too much backup tape to backup every day. Is there any way that after a online backup has been done DB2 will move the logs not needed for the roll forward process to another folder(possibly a mapped drive on the network)? I keep hearing something about a user exit command?
I don't think USEREXIT is going to help in this case: it only copies the archived log files as they are being generated; I don't think it can determine whether a certain log file is not needed for recovery.
I guess you could use the following approach: use "get db cfg for <database>" to determine the earliest log file needed for recovery (it advances after each backup) and then go and delete logs that are earlier than that file.
Since log files are numbered sequentially it shouldn't be too difficult to write a script to automate this process.