HP NonStop G-Series - Manual (Page 28)

Installing SDR
HP NonStop SQL DDL Replicator User’s Guide —545799-005
2-8
Install EMS templates
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