NonStop SQL DDL Replicator User's Guide (Update 7)
Table Of Contents
- Legal Notices
- 1 Introducing SDR
- 2 Installing SDR
- 3 Configuring SDR
- 4 SDR Operations
- 5 SDR Monitoring and Control
- 6 SDR Commands
- A SQL DDL Statements
- B SDR EMS Messages
- C Testing SDR
- Index

SDR Commands
HP NonStop SQL DDL Replicator User’s Guide—545799-007
6-7
ALTER GLOBAL
If SDR aborts a DDL operation on the primary system, a message is 
logged to EMS to notify the user that DDL capture is REQUIRED, but an 
environmental problem is preventing SDR from capturing the DDL 
operation.
TEST[ING]
disables the capture of DDL operations unless one of the following 
enablers is present:
 the CLASS MAP DEFINE =_SDR_TEST DEFINE has been set or,
an empty file named ENABLSDR is present in the default subvolume 
for the process creator user id. 
EMSCOLLECTOR $collector
a collector process name for all SDR EMS messages.
The default collector is $0.
KEEPPHYSVOL { ON | OFF }
specifies that PHYSVOL specifications in CREATE and ALTER statements 
should always be retained, even if they lead to errors in replication.
The DEFAULT is ON.
MARKERFILES { OFF | ON } 
Controls the creation of Marker files.
ON: SDR creates Marker files. 
OFF: SDR does not create Marker files.
The default is ON..
NETWORK RDF-control-subvol, primary-node, backup-node
used for the replication of DDL operations performed on distributed tables or 
indexes, to provide SDR with the description of the RDF network nodes.
Note. As a usage example, you are advised to set DDLCAPTURE to REQUIRED 
when you install an update to the SDR software, at least until the installation is 
completed on all the systems in the RDF network. See “Updating SDR Software” 
on page 2-8 for further details.
Note.
If the user sets MARKERFILES to OFF on a system where SDR finds 
RDF configurations that require Marker files, the SDR Monitor issues a periodic 
EMS warning to notify the user that it found some RDF configuration that 
needs the Marker files. The warning also displays the text of the ALTER 
GLOBAL command to use to activate the creation of Marker files. The same 
warning is displayed by the STATUS RDF command.










