Administrator Command Reference Manual
Reconfiguration : Reconfiguring Extracts : Example of Reconfiguring a Three Level Extract
Example of Reconfiguring a Three Level Extract
Consider this three-level extract:
All databases must be reconfigured to files first and then reconfigured from the files to the databases, in the order; MASTER, EXT, EXTBOT. If this sequence of operations is not completed, then databases 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 databases. It is therefore suggested that you make backups of databases before reconfiguring them.
The sequence of commands to reconfigure the above three level extract could therefore be:
Note:
The REFRESH, REVERT and MERGE CHANGES commands have not been shown below.
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
It is not necessary for the reconfiguration back from file to be done within the same session of 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 databases 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 database 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 database to locations (C) and (A).
6.
At location C (primary location for EXTBOT)
FROM FILE /EXTBOTA /EXTBOTB
TO DB CTBATEST/EXTBOT
RECONFIG
The whole database will be propagated to locations (A) and (B) automatically.
Steps 4 to 6, reconfiguring from files to databases, should be done consecutively.
1974 to current year. AVEVA Solutions Limited and its subsidiaries. All rights reserved.
AVEVA Logo