NonStop SQL DDL Replicator User's Guide (Update 7)
Table Of Contents
- Legal Notices
- 1 Introducing SDR
- 2 Installing SDR
- 3 Configuring SDR
- 4 SDR Operations
- 5 SDR Monitoring and Control
- 6 SDR Commands
- A SQL DDL Statements
- B SDR EMS Messages
- C Testing SDR
- Index
Introducing SDR
HP NonStop SQL DDL Replicator User’s Guide—545799-007
1-2
Product Overview
Product Overview
SDR installs quickly. Once the product files are in place, you use the SDR command
interpreter, SDRCOM, to issue a few commands that set up a small configuration
database and to install SDR on your system.
SDR is privileged, so the installation of the product files must be performed by
SUPER.SUPER. It does not require a cold load, application outage, or stopping RDF
or TMF. All other operations can be performed by a member of the SUPER group.
SDR must be installed on both RDF primary and backup systems.
SDR requires licensing on each system where it is installed. Before attempting to
install SDR, you must obtain a product licenses from HP, as instructed on the product
CD.
During the installation process, components of SQL are updated and become
dependent on the presence of SDR. Be sure to read the installation section carefully
before attempting to remove or alter the SDR software.
Once installed and licensed, SDR is ready to capture all DDL operations performed on
the system. This happens automatically and is invisible to the SQL users. DDL can be
executed in both SQLCI and in applications; no application or operational changes are
necessary.
When a DDL operation has been captured, SDR uses the RDF configuration
information to translate the DDL to the backup database. SDR coordinates with RDF to
execute the DDL at precisely the right time.
In general, you do not need to start and stop SDR, even if you are starting, stopping or
reinitializing RDF. The SDR monitor is started when SDR is installed and should also
be started whenever the system is cold-loaded. It automatically monitors the RDF state
and activates SDR replication when RDF is started. SDR does not perform any DDL
replication if RDF is stopped.
SDR Components
SDR consists of 4 program files and 6 data files. Each of the program files contains
privileged code and must be licensed.
Program Files
SDR Command Interpreter
The command interpreter, SDRCOM, is the primary user interface for installing,
configuring, and controlling SDR.