HP Integrity NonStop J-Series User Manual

Page 71

Advertising
background image

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.

Advertising
This manual is related to the following products: