Owner manual

HP NonStop SQL DDL Replicator User’s Guide—545799-005
iii
Special cases 4-4
Create Catalog 4-4
CREATE Collation 4-5
User Transactions 4-6
Distributed Tables and Indexes 4-6
Unaudited Tables and Indexes 4-7
SQLCI DUP Utility 4-7
DDL Replication 4-7
SDR Updater Processes 4-7
Normal vs. Takeover Operations 4-7
EMS Messages 4-8
Replication Operations 4-8
Creating the SDR Depot Files on the Backup 4-8
Processing Stop RDF Update Audit Records 4-8
Translating DDL 4-9
Executing DDL 4-10
Restarting RDF Update 4-10
SDR and RDF Takeover 4-10
Distributed Table Replication 4-11
SDR Monitoring and Control 5-1
Checking Status 5-1
EMS Log 5-1
The SDR Log 5-1
STATUS Commands 5-2
STATUS MONITOR 5-2
STATUS SDR 5-3
STATUS RDF 5-3
STATUS UPDATE 5-4
STATUS * 5-4
Controlling Replication 5-4
Monitor-Level Commands 5-5
START UPDATE 5-5
STOP UPDATE 5-5
RESTART UPDATE 5-5
Updater-level Command 5-6
HOLD RDF-control 5-7
RELEASE RDF-control 5-7
EXECUTE RDF-control 5-8