Filter
Top Products
DB2 Manager User Guide 89
StorageTek Proprietary
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