NonStop SQL DDL Replicator User's Guide (Update 6)

SDR Commands
HP NonStop SQL DDL Replicator User’s Guide—545799-006
6-11
CREATE SYSDB
Certain SDR configuration or processing errors make it impossible to determine the
information necessary to restart the RDF updaters. For example, an incomplete RDF
or SDR network specification can make it impossible to restart updaters on all
participating network systems. In this case, CANCEL has no effect and you must use
RDFCOM to restart the updaters.
RDF-control-subvol
the RDF configuration in the format node[suffix-character] that replicates the SQL
object that is the target of the DDL operation.
CREATE SYSDB
Creates the SDR Configuration Database. SysDB consist of the SQL REGISTRY that
resides in a subvolume named SDRSYSDB. REGISTRY is updated with registration
information and global parameters.
SysDB must be created on an audited volume.
volume
volume where SysDB will be created. The default is $SYSTEM.
option
CATALOG SQL-catalog
is the SQL catalog subvolume where the SysDB table is registered.
You can also select the catalog by specifying a catalog attribute for the
=_DEFAULTS define.
If the SQL-catalog parameter is omitted, SDRCOM creates a SQL catalog on
the same volume as the SysDB in a subvolume called SDRCATLG.
Following the creation of the system database, you should comply with the
registration instructions.
If you create the SysDB on a subvolume other than $SYSTEM.SDRSYSDB,
then some precautions must be taken, mainly to avoid creating more than one
SysDB, because SDR searches all disks for the SYSDB and issue an error if
more than one is found.
CANCEL RDF-control-subvol
CREATE SYSDB [ ON volume ] [, option ]
option is
{ CATALOG SQL-catalog }
{}
{ SECURE "rwep" }