Loudwater
Systems
Management

Steps if you want to move from one DB2 subsys to another

DB2 lacks any concept like 'COPY DATABASE' or even 'COPY TABLESPACE'. The recommended migration route is 'UNLOAD TABLE to temp ds/ RELOAD TABLE from temp ds'. This is horribly low-level, and fiddly for EPDM users who may have 100's of tables.

Recommended route; Use the BMC Alter utility which provides a migrate capability which creates a worklist (54K lines!) and proper JCL (can take sizes into account). Not for the faint-hearted. Steps: 

    1. Use BMC Alter to create a new EPDM installation in the target
       DB2 system.
    2. Delete or rename old ISPPROF(DRLPROF) if shared.
    3. Copy and modify the EXEC, DEFS, CNTL
    4. Start EPDM
    5. Set Dialog Variables
    6. Use %XQF and %IQF to move the QMF objects
    7. Copy the ADMCFORMs.
    8. Test the dialog
    9. Take ICs of everything
    10. Try a Collect job. If it works, you might be in business!
        When similar jobs execute successfully against all TSPACEs,
        then you've succeeded.