NetBase SQL Shadowing Handbook

Installation NetBase SQL
____________________________________________________________
2-14 QUEST Software, Inc. ver A0195
Pseudo-Node Shadowing
If we want to have a pseudo-node process running on each of the machines, on each of the
machines we would also enter the following record:
D> SQLOUT PRODDBE.DATA.PROD,@;PART=1,2,3
The user exit interprets the @ as node zero (0), and may perform whatever is defined for that
node. A common application is to log all update transactions (without logging any of the rest).
SYSA
D> SQLOUT DBE.DATA.PROD,SYSB;HOME=1;USEREXIT
D> SQLOUT DBE.DATA.PROD,SYSC;HOME=1;USEREXIT
D> SQLOUT DBE.DATA.PROC,@;HOME=1,2,3
D> SQLIN DBE.DATA.PROD,SYSB;USEREXIT
D> SQLIN DBE.DATA.PROD,SYSC;USEREXIT
SYSB
D> SQLOUT DBE.DATA.PROD,SYSA;HOME=2;USEREXIT
D> SQLOUT DBE.DATA.PROD,SYSC;HOME=2;USEREXIT
D> SQLOUT DBE.DATA.PROC,@;HOME=1,2,3
D> SQLIN DBE.DATA.PROD,SYSA;USEREXIT
D> SQLIN DBE.DATA.PROD,SYSC;USEREXIT
SYSC
D> SQLOUT DBE.DATA.PROD,SYSA;HOME=3;USEREXIT
D> SQLOUT DBE.DATA.PROD,SYSB;HOME=3;USEREXIT
D> SQLOUT DBE.DATA.PROC,@;HOME=1,2,3
D> SQLIN DBE.DATA.PROD,SYSA;USEREXIT
D> SQLIN DBE.DATA.PROD,SYSB;USEREXIT