NetBase SQL Shadowing Handbook

Installation NetBase SQL
____________________________________________________________
2-24 QUEST Software, Inc. ver A0195
To review SQL shadowing:
*> SHOW SQL
Exporting Status:
# Node DBE Name State PIN
7 CLIENT1 BRN1DBE.PUB.QDBEBRN1 ACTIVE 73
8 DBSERVER CCDBE.ROBIN.NETBASE ACTIVE 39
8 DBSERVER XXDBE.ROBIN.NETBASE INACT 47
Importing Status:
# Node DBE Name State PIN
7 CLIENT1 BRN1DBE.PUB.QDBEBRN1 ACTIVE 119
7 CLIENT1 FOO.PUB.NETBASE ACTIVE 133
7 CLIENT1 HRMSDB.HRMSDTA.REP01 INACT 99
8 DBSERVER CCDBE.SHADOW.NETBASE DOWN
8 DBSERVER SHDBE.SHADOW.NETBASE DOWN
In the above display the STATE field indicates the operating mode for the different exporting and
importing nodes.
• ACTIVE indicates that the local process is running, as is the necessary remote process.
• INACTIVE identifies the situation in which the local process is running, but the remote
process is not.
• DOWN indicates that the local process is not running.
Backups With WSL
When performing backups of an ALLBASE DBE, the SQL shadowing processes should be
stopped. Both the export and import processes open the DBE and the log file.
The STORE command in SQLUTIL does not store the WSL log files; to accomplish that, the
STORELOG command should be used. The STORELOG command stores a single (available)
log file to tape.
WARNING! Do not use STOREONLINE to store the DBE while users are updating the DBE,
because the stored log files are likely to be out of synchronization with the stored DBE.