HP Integrity NonStop H-Series - Manual (Page 70)

SDR Commands
HP NonStop SQL DDL Replicator User’s Guide —545799-006
6-6
ALTER
Setting the global ACCESSID to USER[ID] instructs the SDR updater to use
the same user ID to perform the DDL operation on the backup as was used to
perform the DDL operation on the primary system.
The default is SUPER[ID], which causes all DDL operations, except CREATE,
to be performed under SUPER,SUPER.
AUTOCREATECATALOG { ON | OFF }
specifies that SDR should automatically create catalogs on the backup system,
whenever RDF indicates that a catalog is required. For automatic catalog
creation, RDF must be configured to replicate data for the files in the catalog
subvolume.
Automatic catalog creation is independent of any other SDR facility. RDF may
be referencing a catalog due to reasons unrelated to an SDR DDL operation.
The default is OFF.
CREATEID { user-ID | user-name } {, GIVETOUSER }
sets the owning user ID of any SQL object being created.
The default owner is the user ID that created the primary object.
GIVETOUSER
If the create table operation is executed by SUPER.SUPER on the backup
system, GIVETOUSER gives ownership of the replicated table or catalog
to the original owner of the table on the primary system.
CREATESECURITY “rwep”
sets the SECURE option of any SQL object being created.
DDLCAPTURE { ENABLE[D] | DISABLE[D] | REQUIRED | TEST[ING}
controls the capture of SQL DDL operations on the primary:
ENABLE[D]
enables the capture of all SQL DDL operations, providing
a. the SDR monitor is running, and
b. SDR is licensed and,
c. SDR has been INSTALLed in the SQL utilities.
DISABLE[D]
disables the capture of SQL DDL operations.
REQUIRE[D]