3 configuring sdr, Rdf considerations, Rdf topologies – HP NonStop G-Series User Manual

Page 33: Rdf configuration, Replicatepurge, Network and networkmaster, Configuring sdr 3-1, Rdf considerations 3-1, Rdf topologies 3-1, Rdf configuration 3-1

Advertising
background image

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

Advertising
This manual is related to the following products: