Procedure to configure DB2 backup with multiple retention levels in single backup policy.

Procedure to configure DB2 backup with multiple retention levels in single backup policy.

Article: 100045930
Last Published: 2019-07-12
Ratings: 0 0
Product(s): Appliances, NetBackup

Problem

Procedure to configure DB2 backup with multiple retention levels in single backup policy.

Error Message

When configured multiple "Application Backup Schedules" to have different retention levels, backup always pickup 1st schedule mentioned in db2.conf

Cause

DB2 backup always pick up schedule mentioned in 1st stanza in db2.conf.

Solution

Perform below mentioned steps:

1) In db2.conf remove SCHEDULE parameter

2) In DB2 backup policy configure multiple "Automatic Schedules" and "Application Backup Schedules". 

Example: If you want to configure Daily and Weekly backup schedule with one-month retention and 6 months retention respectively then perform bellow mentioned steps.

a) Edit db2.conf and remove SCHEDULE parameter from the stanza.

b) In Backup policy create two Automatic Schedules and two Application Backup schedules, one for Daily and one for Weekly as shown below.

For Daily:

Automatic Schedule Name: Daily_Full

Time window: Monday to Friday 6pm to 11pm

Application Backup Schedule Name: Daily_Application_Backup

Time window: Monday to Friday 6pm to 11pm

             Retention: 1 Month.

 

             For Weekly:

Automatic Schedule Name: Weekly_Full

Time window: Every Saturday 6pm to 11pm

Application Backup Schedule Name: Weekly_Application_Backup

Time window: Every Saturday 6pm to 11pm

             Retention: 6 Months. 

When “Daily_Full” Schedule starts, it will find only “Daily_Application_Backup” schedule as available to run the job which has retention of 1 month.

When “Weekly_Full” Schedule starts, it will find only “Weekly_Application_Backup” schedule as available to run the job which has retention of 6 months.

(Note: Schedule, Time, Retention mentioned in the above example are just for guidance, please change them as per your requirement.)

Important: Make sure that these multiple "Application Backup Schedules" and "Automatic Schedules" do not have overlapping date time window. Corresponding "Automatic Schedule" and "Application Backup Schedule" should have exact same available date time windows. 

 

Was this content helpful?