Owner manual

HP NonStop SQL DDL Replicator User’s Guide—545799-005

Disabling DDL Capture 2-10

Removing SDR Software 2-10

Changes to RDF Operations 2-10

ZRDF-EVT-Msg-736 2-11

ZRDF-EVT-Msg-908 2-11

ZRDF-EVT-Msg-700, ZRDF-EVT-Msg-705 2-11

Configuring SDR 3-1

RDF Considerations 3-1

RDF Topologies 3-1

RDF Configuration 3-1

REPLICATEPURGE 3-1

NETWORK and NETWORKMASTER 3-1

Replicating Physical VOLUMEs in an SMF Environment 3-2

INCLUDE and EXCLUDE 3-2

RDF EMS Events and the LOGFILE 3-2

Configuring SDR 3-2

Configuring SDR Capture 3-3

Enabling and Disabling SDR 3-3

Requiring DDL Capture 3-3

Retaining Captured DDL 3-4

Handling DDL Operations performed under a User Transactions 3-4

Configuring SDR Replication 3-5

Setting CREATE Ownership and Security 3-5

Setting the User ID for Replicated DDL Operations 3-6

Automatic Catalog Creation 3-6

Replicating Unaudited Tables 3-7

Configuring the SDR Network 3-7

SDR Operations 4-1

SDR Monitor 4-1

SDR Fundamental Concepts 4-1

Rule 1 - DDL Capture 4-2

Rule 2 - DDL Replication 4-2

DDL Capture 4-2

DDL Capture Artifacts 4-2

SDR Depot Files 4-3

Stop RDF Update Audit Records 4-3

Marker Files 4-3

DDL Capture Operation 4-4