Configuring sdr, Configuring sdr capture, Enabling and disabling sdr – HP Integrity NonStop J-Series User Manual
Page 35: Testing ddl capture, Requiring ddl capture, Configuring sdr 3-3, Configuring sdr capture 3-3, Enabling and disabling sdr 3-3, Testing ddl capture 3-3, Requiring ddl capture 3-3
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
command and reset to
their default with the
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
The following paragraphs describe global settings that control DDL capture:
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
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