Document Outline

• Legal Notices
• 1 Introducing SDR
  • Introduction
  • Product Overview
  • SDR Components
    • Program Files
      • SDR Command Interpreter
      • SDR Monitor ($ZSDR)
      • SDR Runtime
      • SDR Updater
    • Data Files
      • SDRERROR
      • SDRHELP
      • ZSDRTMPL
      • SDRFLTR
      • ZCOMTMPL and COMFLTR
  • NonStop Kernel and RDF Compatibility
• 2 Installing SDR
  • Prerequisites
  • Initial Installation
    • Move Files from the Product Media to the Installation Subvolume
    • Install Product Files
    • Start an EMS distributor
    • Create the SDR System Database
    • Install the SDR License
    • Enable SQL for DDL Replication
    • Install EMS templates
    • Update System Coldload Procedures
  • Updating SDR Software
    • Install Product Files for SDR Update
  • Enabling DDL Capture when Updating NonStop SQL Software or the Operating System
  • Disabling DDL Capture
  • Removing SDR Software
  • Changes to RDF Operations
    • ZRDF-EVT-Msg-736
    • ZRDF-EVT-Msg-908
    • ZRDF-EVT-Msg-700, ZRDF-EVT-Msg-705
• 3 Configuring SDR
  • RDF Considerations
    • RDF Topologies
    • RDF Configuration
      • REPLICATEPURGE
      • NETWORK and NETWORKMASTER
      • Replicating Physical VOLUMEs in an SMF Environment
      • INCLUDE and EXCLUDE
      • RDF EMS Events and the LOGFILE
  • Configuring SDR
    • Configuring SDR Capture
      • Enabling and Disabling SDR
      • Requiring DDL Capture
      • Retaining Captured DDL
      • Handling DDL Operations performed under a User Transactions
    • Configuring SDR Replication
      • Setting CREATE Ownership and Security
      • Setting the User ID for Replicated DDL Operations
      • Automatic Catalog Creation
      • Replicating Unaudited Tables
      • Configuring the SDR Network
• 4 SDR Operations
  • SDR Monitor
  • SDR Fundamental Concepts
    • Rule 1 - DDL Capture
    • Rule 2 - DDL Replication
  • DDL Capture
    • DDL Capture Artifacts
      • SDR Depot Files
      • Stop RDF Update Audit Records
      • Marker Files
    • DDL Capture Operation
    • Special cases
      • Create Catalog
      • CREATE Collation
      • User Transactions
      • Distributed Tables and Indexes
      • Unaudited Tables and Indexes
      • SQLCI DUP Utility
  • DDL Replication
    • SDR Updater Processes
      • Normal vs. Takeover Operations
      • EMS Messages
    • Replication Operations
      • Creating the SDR Depot Files on the Backup
      • Processing Stop RDF Update Audit Records
      • Translating DDL
      • Executing DDL
      • Restarting RDF Update
  • SDR and RDF Takeover
  • Distributed Table Replication
• 5 SDR Monitoring and Control
  • Checking Status
    • EMS Log
    • The SDR Log
    • STATUS Commands
      • STATUS MONITOR
      • STATUS SDR
      • STATUS RDF
      • STATUS UPDATE
      • STATUS *
  • Controlling Replication
    • Monitor-Level Commands
      • START UPDATE
      • STOP UPDATE
      • RESTART UPDATE
    • Updater-level Command
      • HOLD RDF-control
      • RELEASE RDF-control
      • EXECUTE RDF-control
      • CANCEL RDF-control
      • RETRY RDF-control
• 6 SDR Commands
  • Running the Command Interpreter
  • Command Syntax
  • Command Description Overview
  • SDR Configuration and Management Commands
    • ALTER
    • CANCEL
    • CREATE SYSDB
    • EXECUTE
    • HOLD
    • INFO GLOBALS
    • INFO RUNTIME
    • INSTALL RUNTIME
    • INSTALL SDR
    • READLOG
    • RELEASE
    • RESET
    • RESTART UPDATE
    • RETRY
    • START MONITOR
    • START UPDATE
    • STATUS *
    • STATUS RDF
    • STATUS SDR
    • STATUS UPDATE
    • STOP MONITOR
    • STOP UPDATE
    • UNINSTALL SDR
  • Utility Commands
    • ABEND MONITOR
    • ALTER FILE
    • COPY
    • COMMENT
    • DELAY
    • ENV
    • EXIT
    • FC AND!
    • FILEINFO
    • FILES
    • HELP
    • HISTORY
    • LOG
    • MONITOR
    • OBEY
    • OUT
    • RESET
    • RUN[D]
    • SEMICOLON
    • STATUS MONITOR
    • TIME
    • VOLUME
  • Monitor Commands
    • EMSLEVEL
    • LOG
    • STATUS
    • BACKUPCPU
    • SWITCH
• A SQL DDL Statements
  • DDL Statements
  • SQL object in Statement
  • Catalog References in Statements
  • PHYSVOL References in Statements
  • WITH SHARED ACCESS Clauses
• B SDR EMS Messages
  • Informational Messages
    • 101
  • Critical Messages
• C Testing SDR
  • Overview
  • Setting up the Test Environment
    • Testing
    • Moving to production
  • Testing automated operations on the primary
• Index