Owner manual

HP NonStop SQL DDL Replicator User’s Guide—545799-005
3-1
3 Configuring SDR
This section discusses the SDR configuration options and, because many functions of
SDR depend on proper configuration of RDF, a few pertinent RDF considerations. The
chapter is organized as follows:
RDF Considerations
•
RDF Topologies
•
RDF Configuration
•
Configuring SDR
•
Configuring SDR Capture
•
Configuring SDR Replication
RDF Considerations
RDF Topologies
SDR supports all RDF topologies (as described in the RDF - 1 – Features).
RDF Configuration
For the most part, you configure RDF in the normal way, without regard for SDR.
However, there are a few RDF configuration options you need to consider.
REPLICATEPURGE
The REPLICATEPURGE option instructs RDF to automatically replicate Enscribe file
purge operations (RDF 3 – Setting Global Parameters). Some installations disable this
option in order to retain the backup database in case a user accidentally purges a
critical primary file. Others perform regular file purges and would be inconvenienced if
RDF stopped updating every time this happened.
When RDF REPLICATEPURGE is ON, SDR adopts the RDF setting and replicates
DROP operations. If RDF automatically replicates purges, SDR automatically
replicates DROP operations.
When RDF REPLICATEPURGE is OFF, there is a significant difference between RDF
and SDR. While RDF simply ignores the purge (this usually leads to an updater error
10 at some future time), SDR issues EMS messages and holds off replication until the
user decides to either execute or cancel the DROP statement.
NETWORK and NETWORKMASTER
The proper definition of an RDF network is of great importance to SDR if you perform
DDL on distributed tables with secondary partitions or indexes remote from the primary