StorageTek 312564001 User Manual

 

 

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. 

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