NetBase SQL Shadowing Handbook

Installation NetBase SQL
____________________________________________________________
2-20 QUEST Software, Inc. ver A0195
For example:
: ISQL
isql=> START DBE 'ourdbe.data' NEWLOG <CR>
> HOMEPARTITION = 2, <CR>
> MAXPARTITIONS = 3, <CR>
> WSLID = 'SQLACE', <CR>
> STANDBY LOG <CR>
> LOG DBEFILE sqltemp <CR>
> WITH PAGES = 5000, <CR>
> NAME = 'sqlalog.log'; <CR>
isql=> GRANT DBA TO MGR@NETBASE; <CR>
isql=> COMMIT WORK; <CR>
isql=> BEGIN ARCHIVE; <CR>
isql=> COMMIT ARCHIVE; <CR>
Explanation:
For the DBE named "ourdbe.data" (in the
login account)
use home partition ID "2",
maximum number of partitions of "3",
and WSL ID "SQLACE".
Enable standby logging.
Use the temporary log file named "sqltemp,"
setting the log size to 5000 pages,
and save the log file as a permanent log
named "sqlalog.log."
Since the DBE was created by a user other
than MGR.NETBASE, give MGR.NETBASE
full access to the DBE.
Act on the previously entered commands.
Invoke archive logging. (Must be perfomed on
the master machine; optional on shadow
systems.)