HP NonStop G-Series - Manual (Page 74)

SDR Commands
HP NonStop SQL DDL Replicator User’s Guide —545799-005
6-10
CREATE SYSDB
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.
SECURE “reap”
specifies the READ, WRITE, EXECUTE and PURGE security attributes of
SysDB tables.
After you create SysDB, comply with the product licensing instructions.
CREATE SYSDB [ ON volume ] [, option ]
option is
{ CATALOG SQL-catalog }
{ }
{ SECURE " rwep " }