Owner manual

SDR Commands
HP NonStop SQL DDL Replicator User’s Guide—545799-005
6-9
CANCEL
specifies how SDR will process DDL statements executed under a user
transaction.
ABORT
causes SDR to disallow the execution of a DDL statement within a user
transaction. NonStop SQL already disallows the execution of many DDL
statement within a user transaction; this further extends the prohibition to
include all DDL statements.
When a DDL statement is attempted under a user transaction, SDR writes
a message to the home terminal of the application program and to EMS
and aborts the transaction, which causes the SQL statement to terminate
with error -1353.
HOLD
causes SDR to write a message in the EMS log and wait for the user to
issue an SDRCOM command to either EXECUTE or CANCEL the
statement.
HOLD is the default.
[ASSUME]COMMIT
causes SDR to take the optimistic view that the transaction will eventually
be committed and to replicate the DDL statement to the backup system.
UPDATESTAT[ISTICS] { ON | OFF }
controls the replication of the UPDATE STATISTICS operation. When set to
ON, SDR captures the UPDATE STATISTICS operation and replicates it.
The default is OFF.
CANCEL
Instructs the SDR updater that manages the specified RDF configuration to restart the
RDF updaters without executing a DDL operation that was previously attempted and
did not complete.
Restarting the RDF updaters that are awaiting completion of the DDL statement
replication means that RDF simply proceeds and consequently, the DDL statement is
never replicated.
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.
CANCEL RDF-control-subvol