NetBase SQL Shadowing Handbook

Installation NetBase SQL
____________________________________________________________
2-6 QUEST Software, Inc. ver A0195
5. Make Directory Entries
Instruct NetBase as to which DBEs are to be shadowed. This is accomplished using the
NBDIR program. The SQLOUT command is used to define which DBEs are exporting
updates to which nodes. For each DBE, a separate SQLIN record must be entered for
each node importing updates. These entries take effect with the next SQL shadowing
session (started with either START NETBASE or START SQL within NBCTRL).
In addition to defining which DBEs are to be shadowed, you may use the SQLIN and
SQLOUT commands to invoke user exits and to define pseudo nodes. User exits may
be invoked prior to sending the transaction to the importing machine, prior to applying
the imported transaction, or after applying a troublesome transaction. User exits are
explained in detail in chapter 3, User Exits.
SQLOUT
Defines DBEs for outbound SQL Shadowing
SYNTAX:
D> SQLOUT dbename,node;HOME=home-partition[,part2[,...]]
[;EXECPRI={BS|CS|DS|ES}]
[;FREQ=wakeup-seconds]
[;{INCLUDE|EXCLUDE}]
[;USEREXIT]
[;RESET]
The node name should be specific, unless you are creating a pseudo node. In such
cases, the node must be "@". This is the node to which you are sending the data.
The home partition number is the number of the local copy of the DBE.
The EXECPRI defines the execution priority for the SQL export process. The default is a
linear priority of 152.
The FREQ option allows the user to specify the length of time that the export process
will pause between checks to see if new records have been added to the log file. The
pause only takes effect after a call to get the latest record from the log file does not find
new records. The default is 20 seconds.
INCLUDE/EXCLUDE instructs NetBase to shadow or exclude the tables specified in the
TABLE command for this database.
The USEREXIT parameter specifies that for each transaction received for the defined
file, a user exit routine, named export_user_exit, should be called prior to the
transaction being exported to the other nodes.
The RESET parameter may be used when a previous SQLOUT entry has become
obsolete.