NetBase SQL Shadowing Handbook

NetBase SQL Installation
____________________________________________________________
ver A0195 QUEST Software, Inc. 2-19
Below are some tips on setting these values:
WSL ID This name must be unique across the network. Once
this is set, it should never be changed, unless a master
DBE is being restored on a shadow machine.
(Maximum 8 characters.)
Home partition ID This must be a number between 1 and 32767 (inclusive),
and each copy of the DBE must have a unique home
partition number. Once this is set, it should never be
changed.
Maximum number of Partitions The number of partition instances with which the DBE
may resync. This must be a number between 1 and
880 (inclusive). This number is used to calculate the
size of the log file used by Standby Checkpoint Records.
[MaxNumParts * 72 = number of bytes in the log file].
NOTE: Prior to enabling standby logging, the initial state of the DBE should be set up. All tables
and authorization should be defined, and the database tables should be loaded.
To modify these values and enable Warm Standby Logging:
Enter the following:
: ISQL
isql=> START DBE 'dbenvironmentName' NEWLOG <CR>
> HOMEPARTITION = partitionID, <CR>
> MAXPARTITIONS = maxnumparts, <CR>
> WSLID = 'WSLID name', <CR>
> STANDBY LOG <CR>
> LOG DBEFILE oldtempnameforlog <CR>
> WITH PAGES = logsizeinpages, <CR>
> NAME = 'newnameforlog'; <CR>
isql=> GRANT DBA TO MGR@NETBASE; <CR>
isql=> COMMIT WORK; <CR>
isql=> BEGIN ARCHIVE; <CR>
isql=> COMMIT ARCHIVE; <CR>
Syntax Notes:
No comma after NEWLOG
No comma after STANDBY LOG
No comma after the old log file
name
Semicolon at the end
Semicolon at the end
Semicolon at the end
Semicolon at the end
Semicolon at the end