HP NonStop G-Series User Manual

Page 71

Advertising
background image

SDR Commands

HP NonStop SQL DDL Replicator User’s Guide 545799-005

6-7

ALTER

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

specifies 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.

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.

RDF-control-subvol is an RDF configuration in the format node[suffix-
character
].

primary-node and backup-node are the names of the primary and backup
systems respectively

Specifying NETWORK is not required and is not recommended for RDF/IMPX
installations, where SDR extracts the necessary network information from the
RDF NETWORK configuration.

There is no SDR “master” network node. A complete description of the RDF
network must be entered on every node, both primary and backup.

There can be no more than 31 NETWORK globals.

RDFCONFIG { RDF-control-subvol | DEFAULT }
{ AUTO[MATIC] | MANUAL | NOREPL[ICATE] }

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.

Advertising
This manual is related to the following products: