Optimized Management of Copies in the Utility Batch Window

MasterCopy automatically manages backup copies of DB2 Tablespaces based on the restore criteria defined on the site, and takes time constraints into account (utility batch window).MasterCopy manages both FICs (Full Image Copy) and IICs (Incremental Image Copy).The DBA selects a list of objects to be analyzed and the time allocated to the copies.

Analysis, Ordering and Scheduling of Copies

MasterCopy ranks copies by order of importance of execution and integrates time and relation constraints so that all the processes are run in the right order and establishes its processing schedule based on the resources allocated.

Iterative Update of the Processing Schedule

The schedule takes into account the time allocated to the copies and makes sure they are finished before the deadline. MasterCopy updates the schedule after each process taking the host resources available and the current system load into account.A set of coefficients kept up to date based on machine performance allows estimation of the time required for each FIC.

A Simple Operating Model

• Groups of objects are defined based on generic name criteria (e.g. DB1 %, TS1 %)
• The execution parameters to be used are defined (e.g. five days between FICs).

Based on the parameters defined in the groups of objects and the execution parameters, backups can be in three states:- Mandatory copy (maximum time between two FICs reached or Tablespace in CopyPending state)- Optional copy (update limit not reached)- Copy unnecessary (minimum time between two FICs not reached).

DBA Strategy Managed by MasterCopy

MasterCopy takes into account the minimum number of FICs to be saved and the time during which Tablespace restore must be possible (parameters defined during execution or in the object groups).

MasterCopy ends by consistently deleting the objects not needed for recovery (old logs, FICs, IICs).

For each object to be processed and each parameter, MasterCopy uses the most restrictive group specifying a setting for the parameter (or else it uses the default settings).