NetBase SQL Shadowing Handbook

NetBase SQL Installation
____________________________________________________________
ver A0195 QUEST Software, Inc. 2-9
Renaming DBEs
It should be noted that the link between the SQLOUT and SQLIN matching pair is formed by the
name of the DBE on the shadow (or import) side combined with the export node and the import
node. If the name of the DBE on the import side is not the same as the name of the DBE on the
export side, the SQLOUT record needs to specify the remote name. For instance, if the name of
the master DBE is DBE and the name of the shadow DBE is PRODDBE, the following record
should be entered on the export machine:
D> SQLOUT DBE.DATA.PROD,SYSB;HOME=1
Note that only the file name is used, not the group or account. So, multiple entries with the same
file name (with different groups and accounts) may not be used, as the directory entry only keeps
the file name (and assumes the group and account). The SQLIN record on the import machine
would be:
D> SQLIN PRODDBE.DATA.PROD=DBE,SYSA
SYSA
D> SQLOUT DBE.DATA.PROD,SYSB;HOME=1
SYSB
D> SQLIN PRODDBE.DATA.PROD=DBE,SYSA