NetBase SQL Shadowing Handbook

____________________________________________________________
ver A0195 QUEST Software, Inc.
NetBase SQL Shadowing
Index
C
Concurrent updates.................................3-3
CONFIG...........................................2-3, 2-4
commands
ADD ...........................................2-4
LIST ...........................................2-5
MODIFY .....................................2-4
fields
Node Name ................................2-4
System Name.............................2-4
E
Enable SQL Shadowing ..........................2-3
Enable WSL..........................................2-18
Error Messages.......................................4-5
Error Recovery......................................4-12
H
How to
Partially shadow DBEs by excluding
tables...............................................2-15
Partially shadow DBEs by including
tables...............................................2-15
Perform backups with WSL..............2-24
Rename DBEs ...................................2-9
Shadow from multiple masters to one
shadow (consolidated)......................2-11
Shadow from one master to multiple
shadows...........................................2-10
Shadow in several directions............2-12
Size the SCR log file........................2-19
Start/Stop SQL Shadowing...............2-23
Store WSL logfiles ...........................2-24
Use a Pseudo-Node .........................2-14
View SQL shadowing statuses..........2-24
How to Recover from an Out of Sync
Condition...............................................4-13
How to Resync......................................4-13
I
Installation
Loopback network interface................2-1
NMMGR concerns
Connection tables.......................4-2
Network Transport Tables...........4-2
NS tables....................................4-2
Retransmission Interval Lower
Bound.........................................4-2
Socket tables..............................4-2
SECURITY/3000................................2-2
STREAMX (from VESOFT)................2-2
Summary...........................................2-1
ISQL commands
START DBE NEW...........................2-18
N
NBCTRL .................................2-3, 2-4, 2-23
commands
SHOW SQL .............................2-24
START/STOP SQL ..................2-23
START/STOP SQLIN...............2-23
START/STOP SQLOUT...........2-23
NBDIR .............................................2-6, 2-8
entries
SQLIN.....2-3, 2-6, 2-9, 3-1, 3-3, 4-3
SQLOUT ......2-3, 2-6, 2-9, 2-15, 3-1
TABLE ..............................2-6, 2-15
NBEXPSQL.CAT ...........................3-6, 3-10
NBSQLEXP.NB ........................2-3, 3-1, 4-4
NBSQLIMP.NB ..................2-3, 3-1, 3-3, 4-4
NETACCT...............................................2-2
NETBASE.JOB.NETBASE......................3-2
P
Partition number ............1-1, 2-18, 2-19, 3-1
Post Exit Procedure Calling
Conventions............................................3-9
post_sql_exit_before...............................3-2
post_user_exit_after ...............................4-5
Problems
Complications with SECURITY/3000..2-2
Complications with VESOFT's
STREAMX .........................................2-2
Datacomm failure ............................4-12
Deadlock............................................4-1
Excessive network timeouts...............4-2
Pseudo-node......................1-1, 2-6, 3-1, 3-6
R
Resync’ing ............................................4-13
S
Solutions.................................................4-1
SQL ERRORS ......................................4-12