NetBase SQL Shadowing Handbook

Installation NetBase SQL
____________________________________________________________
2-18 QUEST Software, Inc. ver A0195
6. Enable Warm Standby Logging
Prior to enabling WSL, each DBE should be checked to verify that it has a valid WSL ID
and Home Partition ID number, and the Maximum Number of Partitions is set. When an
SQL database is created (via the START DBE NEW command in ISQL), by default
these elements are initialized to zero. (Actually, WSL ID is initialized to blanks.) Each of
these items must have bona fide values for standby logging to work.
1. To verify that these variables have valid values:
: SQLUTIL
>> SHOWDBE
DBEnvironment Name: <<your dbe's name>>
Maintenance Word: <CR>
Output File Name (opt): <CR>
-> ALL
Maintenance word:
DBEnvironment Language: NATIVE-3000
AutoStart: ON
Warm Standby Logging Is: OFF
Warm Standby Logging ID is: MYDBE
Home partition ID Is: 1
Maximum number of Partitions Is: 2
User Mode: MULTI
DBEFile0 Name: CCDBES
DDL Enabled: YES
No. of Runtime Control Block Pages: 37
No. of Data Buffer Pages: 240
Data Buffer Pages Memory Resident: NO
No. of Log Buffer Pages: 120
Max. Transactions: 50
Maximum Timeout: NONE
Default Timeout: MAXIMUM
Authorize Once per Session: OFF
-> E
>> E
If WSL ID is blank, if Home partition ID or Maximum number of Partitions is zero,
you must modify the DBE.