Filter
Top Products
DB2 Manager User Guide 27
StorageTek Proprietary
Define Archive Manager databases
DB2 Manager uses the Archive Manager component of the Lifecycle Director
of DB2 product for storage and retrieval of objects. Migrated rows are held in
one or more Archive Manager databases, one Archive Manager database
being used per DB2 table which has been enabled for migration processing
(ie) there is a one-for-one correspondence between DB2 tables and Archive
Manager databases in the DB2 Manager configuration. This one-for-one
correspondence is enforced during row migration processing.
Each Archive Manager database must be defined prior to first migrating rows
from a DB2 table to DB2 Manager.
Definition of an Archive Manager database is performed using the standard
Archive Manager database administration dialogs under TSO/ISPF. Refer to
the Archive Manager User Manual for a full description of the Archive
Manager database definition procedure.
This section summarizes the procedure for the definition of an DB2 Manager
migrated row database.
1. Logon to the Archive Manager database administration dialog in
TSO/ISPF. Consult the person(s) responsible for Archive Manager
database administration in your installation if you are unsure of how to
invoke this facility.
2. From the main Archive Manager database administration menu, enter the
name to be assigned to the database’s primary index dataset in the
‘primary index name’ field. Any valid unique name may be chosen for this
dataset.
Select option 3 from this menu, and press ENTER. Panel OTSN4300
(the base database definition panel) will be displayed.
3. Fields on panel OTSN4300 should be entered as follows (see Figure 1):
Length of primary
key
Enter the value ‘4’.
Archive Manager
user SVC no
Enter the user SVC number allocated for
Archive Manager during the product installation
procedure. This must be a numeric value in the
range 200-255. Consult the person(s)
responsible for installing Archive Manager on
your system if you are unsure of this value.
HLQ for this
database
Enter the 1-30 character high level qualifier to be
assigned by Archive Manager for all system
datasets created within the database.