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

Installing SDR
HP NonStop SQL DDL Replicator User’s Guide—545799-006
2-10
Disabling DDL Capture
Disabling DDL Capture
To disable SDR DDL capture, set the DDLCAPTURE global parameter to DISABLED
using SDRCOM command ALTER:
SDR displays a message in the EMS log and STATUS SDR shows the following:
Removing SDR Software
If you have enabled SQL for SDR, you must remove SDR from the SQL utilities before
you remove the SDR software from your system. If SDR is not “uninstalled” and the
SDR software is removed from your system, DDL operations on the primary system
will fail.
To remove SDR from your system:
1. In SDRCOM, issue the UNINSTALL SDR command. Like INSTALL SDR,
UNINSTALL SDR performs the necessary duplications and rename operations to
account for the possibility that the SQL utilities are in use at the time the command
is executed. UNINSTALL SDR also stops the SDR monitor.
2. Use SQLCI to purge the REGISTRY table in the SDRSYSDB subvolume.
3. Purge the SDR software in SDR subvolume $SYSTEM.SDR or the subvolume
where it was installed.
4. Update your system startup and shutdown procedures to remove the commands
that start and stop the SDR monitor process.
Changes to RDF Operations
The function of SDR is to automate the replication of SQL DDL statement to backup
tables, thereby performing operations that were previously done manually by
operators. Moreover, to perform these functions, SDR coordinates its activities with
RDF by monitoring RDF events. The installation of SDR on your system therefore calls
SDRCOM 1? alter global ddlcapture disabled;
--- SDR Global SDRDDLCAPTURE updated.
--- Monitor $ZSDR globals refreshed.
SDRCOM 2? status sdr
* Warning 1810 * SQL DDL Capture is disabled.
SDR monitor $ZSDR (0,817) is monitoring 1 RDF environment(s).
Current SDRUPDT processes: 1
Total SDRUPDT processes: 6
-----------
RDF ATOMJ (\ATOM -> \SIERRA) at 4/28/08 13:52:42
Current State: Normal
SDR Updater \SIERRA.$Y27G, holding
No replications performed by this SDR updater.