NetBase SQL Shadowing Handbook

NetBase SQL Installation
____________________________________________________________
ver A0195 QUEST Software, Inc. 2-7
SQLIN
Defines DBEs for inbound SQL Shadowing
SYNTAX:
D> SQLIN dbename[=remname],node [;PRI=transaction-priority]
[;EXECPRI={BS|CS|DS|ES}]
[;USEREXIT]
[;RESET]
The node, in this case, is the node from which data is coming.
The PRI option is used to set the priority on the BEGIN WORK for the transaction being
applied. This is important in the case of deadlocks. The import process should have the
highest priority of all the processes on the system, because HP resolves a deadlock by
aborting the process with the lowest priority. The valid range is 0 to 255 with the highest
priority going to the lowest number. The default is 0.
The EXECPRI option defines the execution priority for the SQL export process. The
default is CS.
The USEREXIT parameter specifies that an import user exit routine, named either
post_sql_exit_before or post_sql_exit_after, should be called with each transaction
received for the defined file. (The post_sql_exit_before routine is applied prior to
posting the imported transaction. The post_sql_exit_after routine is called only if an
apply fails.)
The RESET parameter may be used when a previous SQLIN entry has become
obsolete.
On the following pages are examples of the necessary NBDIR entries for different
shadowing scenarios.