Replicating unaudited tables, Configuring the sdr network, Replicating unaudited tables 3-7 – HP NonStop G-Series User Manual
Page 39: Configuring the sdr network 3-7
Configuring SDR
HP NonStop SQL DDL Replicator User’s Guide —545799-005
3-7
Configuring SDR Replication
Replicating Unaudited Tables
SDR is designed to operate in conjunction with RDF, to perform DDL replication
automatically and at exactly the right time, relative to RDF audited data replication.
Thus, it is designed primarily for audited tables.
SDR can be configured to replicate DDL for unaudited SQL operations, by setting the
global parameter UNAUDITEDDDL. It cannot, however, coordinate DDL replication
with any data operations, so this feature might have limited usefulness in your
environment.
Configuring the SDR Network
To create and perform DDL operations on distributed tables, with partitions and
indexes on multiple systems, SDR must have an accurate picture of all the RDF
configurations, including the primary and backup systems for each one.
If you have installed RDF IMPX, it is preferable that you use the RDF NETWORK
configuration to do this. RDF has excellent verification capabilities to ensure that the
configuration is complete and consistent.
If you do not have RDF IMPX (or do not want to configure RDF for network
transactions) you can configure SDR to specify the primary and backup systems for all
of the affected RDF configurations, using the NETWORK global parameter.
Note that, within SDR, an SDR network configuration overrides any RDF network
configuration.