NetBase SQL Shadowing Handbook

NetBase SQL Installation
____________________________________________________________
ver A0195 QUEST Software, Inc. 2-11
Consolidated SQL Shadowing
Or, you may want to export updates from DBEs on a number of nodes to a master (consolidated)
copy on one machine. Notice that in this case our terminology involving the word "shadow" is
reversed. In this set up, the DBEs on each of the export machines is unique, and the master
copy is a combination of them all. For example, let's export updates to DBE from SYSA, SYSB,
and SYSC to SYSD. On SYSA we enter:
D> SQLOUT DBE.DATA.PROD,SYSD;HOME=1
On SYSB:
D> SQLOUT DBE.DATA.PROD,SYSD;HOME=2
On SYSC:
D> SQLOUT DBE.DATA.PROD,SYSD;HOME=3
And on SYSD:
D> SQLIN DBE.DATA.PROD,SYSA
D> SQLIN DBE.DATA.PROD,SYSB
D> SQLIN DBE.DATA.PROD,SYSC
SYSA
D> SQLOUT DBE.DATA.PROD,SYSD;HOME=1
SYSB
D> SQLOUT DBE.DATA.PROD,SYSD;HOME=2
SYSC
D> SQLOUT DBE.DATA.PROD,SYSD;HOME=3
SYSD
D> SQLIN DBE.DATA.PROD,SYSA
D> SQLIN DBE.DATA.PROD,SYSB
D> SQLIN DBE.DATA.PROD,SYSC