NetBase SQL Shadowing Handbook

____________________________________________________________
ver A0195 QUEST Software, Inc. 4-1
Chapter 4
Troubleshooting
This chapter contains notes and tips concerning running NetBase SQL Shadowing, as well as
error messages which appear when the software has encountered a problem. If NetBase SQL is
not performing as you expect, review the notes in this section to determine what may need to be
changed. At the end of this section is a listing of the error messages associated with NetBase
SQL. Listed with each message is a description and a solution. At the end of this chapter is a
section on data recovery for the synchronization error situations.
Common mistakes
• LOOPBACK is not started. To start issue NETCONTROL START NET=LOOP at a
colon prompt.
• WSL ID is blank or duplicated elsewhere in the system. For successful WSL, for each
copy of each DBE, the WSL ID must be unique within the system.
• Home_partition is zero or duplicated elsewhere in the system. For successful WSL,
each copy of each DBE must have a unique home_partition ID.
• Max_num_partitions is zero. For successful WSL, this value must be between 1 and
880. It should not be too large as it is multiplied by 72 to define the size of the log file for
Standby Checkpoint Records. For more information, please see chapter 2.
• To insure that busy systems can continue to process without their connection with the
shadow machine for a day or two without creating a hard-resync situation, define at
least ten logfiles of 5,000 pages. (The maximum number of logfiles is 32)
• The SQL import process should have the highest transaction priority in case the system
becomes deadlocked, since HP resolves deadlocks by aborting processes with the
lowest priorities until the system is freed. (Highest priorities are the lowest numbers in
the range 0-255.)
• The SQLOUT commands attempt to rename multiple files with the same name (but
different groups and accounts). For example:
D> SQLOUT ACCTG.DATA.PROD=DBE1.DATA.PROD,SYSB
D> SQLOUT ACCTG.BACK.SYS=DBE2.DATA.PROD,SYSB
In the above example, the SQLOUT commands would build two files named ACCTG.
The import process on SYSB would not know which ACCTG file to apply where.