HP NonStop G-Series - Manual (Page 72)

SDR Commands
HP NonStop SQL DDL Replicator User’s Guide —545799-005
6-8
ALTER
used to support parallel RDF configurations (most commonly production and
test) that may share RDF protected volumes, to avoid disrupting the specified
RDF configuration (most commonly production).
RDF-control-subvol is an RDF configuration in the format node[suffix-
character].
DEFAULT applies to all RDF configurations that do not have an explicit
RDFCONFIG setting.
AUTOMATIC
The SDR Updater automatically replicates SQL DDL for the specified RDF
configuration, subject to any other control such as HOLD, RELEASE and
so on.
AUTOMATIC is the default.
MANUAL
If a SQL DDL target object (table, index, so on) is protected by an RDF
configuration, the SDR Updater enters a hold state to allow the user to
manually examine and control replication. The user should issue a
CANCEL or EXECUTE command to proceed and restart RDF updating.
NOREPL[ICATE]
The SDR Updater does not replicate any SQL DDL operation for the
specified RDF configuration and restarts RDF updaters immediately when
the RDF updaters stop for the NSA Stop Update generated by SDR.
Note that AUTOCREATECATALOG is not active when NOREPLICATE is
configured.
RETENTION n { HOURS | DAYS | WEEKS }
sets the retention period for SDR Depot records that store captured DDL
operations.
The minimum retention period is 24 hours. If the user sets it to a smaller value,
SDR rounds it up to 1 day.
The maximum retention time is 60 days.
The default is 1 week.
UNAUDITEDDDL { ON | OFF }
specifies how SDR will process DDL statements for unaudited tables.
If set to ON, SDR will replicate and apply DDL statements for unaudited tables,
even if DML statements are not replicated by RDF.
The default is OFF
USERTRAN[SACTION] { ABORT | HOLD | [ASSUME]COMMIT }