NonStop SQL DDL Replicator User's Guide (Update 7)

Configuring SDR
HP NonStop SQL DDL Replicator User’s Guide—545799-007
3-3
Configuring SDR
Configuring SDR
The following paragraphs describe global settings that control the capture and
replication of DDL operations.
The global settings are changed using the ALTER GLOBAL command and reset to
their default with the RESET command.
To issue the ALTER and RESET commands you must be a SUPER user and have
update access to the REGISTRY table in the SDRSYSDB subvolume.
Configuring SDR Capture
Configuring SDR Replication
Configuring SDR Capture
The following paragraphs describe global settings that control DDL capture:
Enabling and Disabling SDR
Requiring DDL Capture
Retaining Captured DDL
Handling DDL Operations performed under a User Transactions
Enabling and Disabling SDR
It is highly recommend to leave the SDR monitor running at all times. If it becomes
necessary to disable DDL capture for any reason, it can be done by setting the
DDLCAPTURE global parameter to DISABLED.
Testing DDL Capture
When SDR is first installed, you may wish to test its functionality without enabling DDL
capture for all users. To do this you can set the global parameter DDLCAPTURE to
TESTING. This is similar to DISABLED but allows you to enable DDL capture on a
selective basis. See Appendix C, Testing SDR for more details.
Requiring DDL Capture
When a DDL operation is performed on a SQL table, operational problems could
prevent SDR from capturing and preserving the DDL statement for replication. For
example, if the SDR monitor is stopped, DDL capture is impossible, or if a security
error prevents SDR from accessing its own files, then the statement cannot be stored.
The capture problem on the primary table might cause the backup table to become
inconsistent or unusable.
ALTER [GLOBAL] parameter-and-value