Example of Reconfiguring a Three Level Extract

Consider this three-level extract:

All Databases (DBs) must be reconfigured to files first and then reconfigured from the files to the DBs, in the order; MASTER, EXT, EXTBOT. If this sequence of operations is not completed, then the DBs will be corrupted.

For example, if EXTBOT is not reconfigured from file, then EXTBOT will be corrupted as a result of the reconfiguration of the other two DBs. It is therefore suggested that the administrator makes backups of DBs before reconfiguring them.

The sequence of commands to reconfigure the above three-level extract could therefore be:

FROM DB CTBATEST/MASTER

TO FILE /MASTERA /MASTERB

RCFCOPY ALL

RECONFIG SESSIONS

FROM DB CTBATEST/EXT

TO FILE /EXTA /EXTB

RCFCOPY ALL

RECONFIG SESSIONS

FROM DB CTBATEST/EXTBOT

TO FILE /EXTBOTA /EXTBOTB

RCFCOPY ALL

RECONFIG SESSIONS

FROM FILE MASTERA /MASTERB

TO DB CTBATEST/MASTER

RECONFIG

FROM FILE EXTA /EXTB

TO DB CTBATEST/EXT

RECONFIG

FROM FILE EXTBOTA /EXTBOTB

TO DB CTBATEST/EXTBOT

RECONFIG

Note:
The REFRESH, REVERT and MERGE CHANGES commands have not been shown above.

It is not necessary for the reconfiguration back from file to be done within the same session of the RECONFIGURER. For example, in a Global Project where MASTER, EXT and EXTBOT are Primary at different Locations, then the following sequence could be followed:

1. At Location A (Primary Location for MASTER):

   FROM DB CTBATEST/MASTER TO FILE /MASTERA /MASTERB RCFCOPY ALL RECONFIG SESSIONS

2. At Location B (Primary Location for EXT):

   FROM DB CTBATEST/EXT TO FILE /EXTA /EXTB RCFCOPY ALL RECONFIG SESSIONS

3. At Location C (Primary Location for EXTBOT):

   FROM DB CTBATEST/EXTBOT TO FILE /EXTBOTA /EXTBOTB RCFCOPY ALL RECONFIG SESSIONS

   Steps 1 to 3, reconfiguring from DBs to files, can be done in parallel.

4. At Location A (Primary Location for MASTER):

   FROM FILE /MASTERA /MASTERB TO DB CTBATEST/MASTER RECONFIG

   The User must now propagate the whole DB to Locations B and C.

5. At Location B (Primary Location for EXT):

   FROM FILE /EXTA /EXTB TO DB CTBATEST/EXT RECONFIG

   The User must now propagate the whole DB to Locations C and A.

6. At Location C (Primary Location for EXTBOT):

   FROM FILE /EXTBOTA /EXTBOTB TO DB CTBATEST/EXTBOT RECONFIG

   The whole DB will be propagated to Locations A and B automatically.

Steps 4 to 6, reconfiguring from files to DBs, should be done consecutively.