StorageTek 312564001 manual Archive Manager database backup and recovery

Reorganization of other (non-migrated) partitions in the tablespace should be performed as normal. Regular reorganization will, in particular, be required for a period of time after implementation of DB2 Manager migration, in order to reclaim disk space occupied by rows which have been migrated to Archive Manager. This will allow these tablespace partitions to be reduced in size, eventually down to the size needed for the “working-set” of unmigrated rows (ie) rows which have yet to be migrated to Archive Manager.

Reorganization of one or more partitions of a partitioned tablespace is accomplished through the use of the PART keyword on the REORG TABLESPACE utility command. Refer to the appropriate DB2 Utility Guide and Reference manual for a complete description of this process.

Archive Manager database backup and recovery

Archive Manager database backup

After completion of the table migration process, standard Archive Manager database backup procedures should be implemented, as documented in the Archive Manager User Manual. The following Archive Manager database system files should be backed up, using standard disk backup procedures:

•Primary index dataset

•Storage level 0 space management dataset

•Journal dataset (optional – only required if journaling is enabled for the Archive Manager database).

The tape volume(s) updated or created during table migration processing should be backed up using the Archive Manager database backup utility OTASP110. Standard Archive Manager archival and backup processing enables the creation of up to 4 copies of each tape volume in an Archive Manager database. The copies are identified as follows:

‘A’ copy - this is the primary copy created when writing objects to an Archive Manager tape database. The primary copy will always exist.

‘B’ copy - this is a backup copy of the primary (‘A’) volume, created via execution of the Archive Manager backup utility (OTASP110).

‘C’ copy - this is a duplex copy of the primary (‘A’) volume. The ‘C’ copy is automatically created when writing objects to an Archive Manager database for which the duplexing facility has been enabled via the Archive Manager database administration facility. The duplex copy is created at the same time as the primary copy (ie) two tape drives will be allocated concurrently by Archive Manager.

‘D’ copy - this is a duplex copy of the backup (‘B’) volume. The ‘D’ copy is automatically created by the Archive Manager backup utility, when backing up a database for which the ‘duplex during backup’ facility has been enabled via the Archive Manager database

DB2 Manager User Guide	89
StorageTek Proprietary