User guide
Manuals
Brands
HP Manuals
Computer Hardware
Integrity NonStop J-Series
61
62
63
64
65
66
67
68
69
70
Table Of Contents
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
Updating NonStop SQL Software or Operating System Software
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
Testing DDL Capture
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 GLOBAL
ALTER MONITOR
CANCEL
CREATE SYSDB
EXECUTE
HOLD
INFO GLOBALS
INFO MONITOR
INFO RUNTIME
INSTALL RUNTIME
INSTALL SDR
READLOG
RELEASE
RESET
RESTART UPDATE
RETRY
START MONITOR
START UPDATE
STATUS RDF-control-subvol
STATUS *
STATUS RDF
STATUS SDR
STATUS UPDATER
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
The RESTORE Utility
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
SDR Monitoring and
Control
HP NonS
top SQL DDL Replicator User
’s Guide
—
545799-007
5-1
2
Updater-level Command
1
...
...
62
63
64
65
66
...
...
132
