NetBase SQL Shadowing Handbook

ver A0195 QUEST Software, Inc.
NetBase SQL Shadowing
Table of Contents
Chapter 1 - Introduction
Who should use this handbook?.....................................................................................1-1
NetBase SQL Shadowing ...............................................................................................1-1
Chapter 2 - Installation
Installation Summary......................................................................................................2-1
1. Restore NetBase from the Installation Tape...............................................................2-2
2. Stream the Installation Job ........................................................................................2-2
3. Configure NetBase Operational Parameters ..............................................................2-3
4. Configure Network Nodes..........................................................................................2-4
5. Make Directory Entries ..............................................................................................2-6
SQLOUT ...............................................................................................................2-6
SQLIN ...................................................................................................................2-7
Examples: Single Direction SQL Shadowing..........................................................2-8
Examples: Renaming DBEs...................................................................................2-9
Examples: Distributed SQL Shadowing................................................................2-10
Examples: Multi-Directional SQL Shadowing.......................................................2-12
Examples: Pseudo-Node Shadowing ...................................................................2-14
Examples:Excluding Tables.................................................................................2-15
6. Enable Warm Standby Logging ...............................................................................2-18
7. Add Additional Required Log Files...........................................................................2-21
8. Start SQL Shadowing ..............................................................................................2-23
Backups With WSL ......................................................................................................2-24
Sample Startup and Backup Jobs.................................................................................2-25
Chapter 3 - User Exits
Overview........................................................................................................................3-1
WSL Flags .....................................................................................................................3-3
Notes on User Exit Structure ..........................................................................................3-4
Export Exit Procedure Calling Conventions ....................................................................3-5
Post Exit Procedure Calling Conventions .......................................................................3-9
Sample User Exit .........................................................................................................3-13
Chapter 4 - Troubleshooting
Common Mistakes..........................................................................................................4-1
Termination Conditions...................................................................................................4-3
SQL Errors ...................................................................................................................4-12
Error Recovery.............................................................................................................4-12
Resync’ing....................................................................................................................4-13