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

Installing SDR

HP NonStop SQL DDL Replicator User’s Guide—545799-005

2-8

Install EMS templates

The file ZSDRTMPL contains EMS templates for all events generated by SDR. The file

ZCOMTMPL contains templates for SDR and RDF events. Please refer to the DSM

Template Services Manual for instructions about installing system templates.

You can use the EMS filter file SDRFLTR with an EMS distributor to display SDR

events, as described above in Start an EMS distributor on page 2-4.

Update System Coldload Procedures

To insure that the replication of DDL operations is active, the monitor process must be

running. You should include the start of the monitor process with the other operational

steps that normally follow a system cold load.

Start the monitor process after TMF has been started and before any DDL operation is

performed on your SQL database. To start the SDR monitor process, use the following

TACL command:

Updating SDR Software

The version of SDR must be the same on the primary and backup systems. If you

update SDR software on the any of the participating systems, you must update the

software on all systems. For a safe and minimal outage, the SDR installation steps

should be executed in the following sequence:

1. On both the primary and backup systems, restore the product media as instructed

in Move Files from the Product Media to the Installation Subvolume

2. On the primary system:

1. Make sure that there are no DDL operations in progress on the primary

system. Use STATUS UPDATE to verify that no operations are in progress.

2. Disallow SQL DDL operations during the period that SDR is unable to capture

them for later replication:

•

In SDRCOM: ALTER GLOBAL DDLCAPTURE REQUIRED

3. In SDRCOM: STOP UPDATE

3. On the backup system (or systems):

1. Replace the SDR software components in the product subvolume using the

INSTALL macro as described below in Install Product Files for SDR Update.

The INSTALL macro restarts the SDR monitor.

2. Install the EMS templates. See Install EMS templates on page 2-8.

4. On the primary system:

RUN $SYSTEM.SDR.SDRCOM START MONITOR