NetBase SQL Shadowing Handbook

Installation NetBase SQL
____________________________________________________________
2-10 QUEST Software, Inc. ver A0195
Distributed SQL Shadowing
Another way a network may be set up is to shadow a DBE from one node to a number of other
nodes. If we are shadowing PRODDBE from MASTER to SHAD1, SHAD2, and SHAD3, then on
MASTER, we enter:
D> SQLOUT PRODDBE.DATA.PROD,SHAD1;HOME=1
D> SQLOUT PRODDBE.DATA.PROD,SHAD2;HOME=1
D> SQLOUT PRODDBE.DATA.PROD,SHAD3;HOME=1
And on each of the other systems, we enter:
D> SQLIN PRODDBE.DATA.PROD,MASTER
MASTER
D> SQLOUT PRODDBE.DATA.PROD,SHAD1;HOME=1
D> SQLOUT PRODDBE.DATA.PROD,SHAD2;HOME=1
D> SQLOUT PRODDBE.DATA.PROD,SHAD3;HOME=1
SHAD1
D> SQLIN PRODDBE.DATA.PROD,MASTER
SHAD2
D> SQLIN PRODDBE.DATA.PROD,MASTER
SHAD3
D> SQLIN PRODDBE.DATA.PROD,MASTER