Owner manual

Installing SDR
HP NonStop SQL DDL Replicator Users Guide545799-005
2-9
Install Product Files for SDR Update
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 monitor with UPDATE.
2. Install the EMS templates. See Install EMS templates on page 2-8.
3. RESET the DDLCAPTURE global parameter if it was set only for the duration
of the installation: RESET GLOBAL DDLCAPTURE.
You do not need to re-issue the INSTALL SDR command.
Install Product Files for SDR Update
When replacing SDR product files, the INSTALL does additional processing to account
for the possibility that the SDR files are in use. INSTALL proceeds as follows:
Warns you that while the software is being replaced, DDL replications could be
lost, and tells you what to do to prevent it.
Prompts you for permission to proceed with the installation. If you are ready, enter
Y.
If the updater object file SDRUPDT is opened, instructs you to STOP UPDATE on
the primary SDR system and to restart INSTALL.
If other SDR product files are opened, instructs you to close them.
Stops the SDR monitor if it is executing.
If the SDRRUNTM is opened because it is in use by a prepared SQL utility,
restores the new SDRRUNTM as NEWRUNTM in the SDR subvolume.
Executes the SDRCOM command INSTALL RUNTIME to replace the existing SDR
runtime with the new version. See description of the command below on page
6-11,
Note also that INSTALL RUNTIME aborts with no change if any of the SQLutil
objects duplicated to the ZASDR.SQLutil for previous installation is still in use and
cannot be purged.
After the product files have been replaced, restarts the monitor. On the primary
system, INSTALL restarts the SDR monitor specifying the UPDATE option.
Enabling DDL Capture when Updating
NonStop SQL Software or the Operating
System
If you install a new version of the operating system or a new version of SQL, you need
to enable the new SQL components for DDL capture and replication, as described
above in Enable SQL for DDL Replication
on page 2-6.