HP NonStop G-Series - Manual (Page 25)

Installing SDR
HP NonStop SQL DDL Replicator User’s Guide —545799-005
2-5
Create the SDR System Database
Create the SDR System Database
The SDR System Database (SysDB) is created using the SDR command interpreter
SDRCOM. When starting SDRCOM during the initial installation, a warning message
appears directing you to create a SysDB and license the SDR product.
You must be a member of the SUPER group in order to create the SysDB. If you are
not logged on as a SUPER user, SDRCOM displays an error message and does not
create the SysDB.
The SUPER user that creates the SYSDB becomes the SDR owner. The SDR owner is
similar to the RDF owner, except that any SUPER user that has update access to the
SysDB REGISTRY table is considered to be an SDR owner.
The SDR owner can start and stop the monitor, issue the INSTALL SDR command,
and perform the SDR control functions described in
Section 5, SDR Monitoring and
Control under Controlling Replication .
To create the SDR SysDB:
1. Log on as a SUPER user
2. Invoke SDRCOM from the TACL prompt:
3. Create the SDR SysDB tables by issuing the CREATE SYSDB command.:
CREATE SYSDB performs the following operations:
7> sdrcom
SHP Nonstop(tm) SDR(tm) Command Interpreter(T2828V01) - System \SIERRA
(C)2010 Hewlett Packard Development Company, L.P.
(C)2010 Carr Scott Software Incorporated
*Warning* The SysDB cannot be found. Issue the CREATE SYSDB command to
* 1601 * create it. Enter HELP CREATE-SYSDB; for more information.
*Warning* Use of SDR requires licensing. To obtain the
* 1801 * licensing key, send an e-mail to [email protected].
* * Please provide your system serial number and order number.
* * This system has serial number 35507.
SDRCOM 1? create sysdb;
--- SysDB table $SYSTEM.SDRSYSDB.REGISTRY created.
--- Starting Monitor process $ZSDR
SDR Monitor 1.9.1 - 29MAR2010 -- $ZSDR (0,221) - System \SIERRA
Started at Mar 18 2010 11:09:20, elapsed time = 0:00:00
Backup process cpu 1, no takeovers
Monitor hometerm: $0
EMS event logging level is NORMAL.
*Warning* Use of SDR requires licensing. To obtain the
* 1801 * licensing key, send an e-mail to [email protected].
* * Please provide your system serial number and order number.
* * This system has serial number 35507.
SDR monitor $ZSDR (0,221) is monitoring 0 RDF environment(s).
Current SDRUPDT processes: 0
Total SDRUPDT processes: 0