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

SDR Commands
HP NonStop SQL DDL Replicator User’s Guide —545799-006
6-9
ALTER
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 }
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.