db2 backup with difference retention
We are facing an issue with db2 monthly backup thru NBU 7.1. Our client server is AIX and db2 version is 9.7. We are using “user exit” method to backup the db. We managed to configure the daily backup & daily transaction logs backup and it work fine. Restoration of the DB2 is also works perfectly.
Our problem starts when we want to configure different retention level between our daily and monthly backup policy. Based on our understanding to configure different retention level between Daily (2 weeks) & Monthly Backup (1 year) we need to configure separate policy for each retention. But when we add in a Monthly Policy (separate script), the Montly Full backup was running as expected but somehow it took the Daily logs policy backup instead of the monthly logs backup. We did tried adding this parameters in the scrips(OPTIONS "DB2_POLICY=policy_name:DB2_SCHED=Schedule_name) but it did not help to solve this issue. Our plan is to configure policies as below :
Daily Policies (retention 2 weeks):
- Daily_DB2 <at the end of this policy it will call Daily_Transaction_Logs policy>
Monthly Policies (retention 1 year):
- Monthly_DB2 <at the end of this policy it will call Monthly_Transaction_Logs policy>
Need NBU gurus to advice on how to make the Monthly db backup trigger the monthly transaction logs instead of the daily transaction policy.
Any help would be appreciated.