User guide

SDR Commands

HP NonStop SQL DDL Replicator User’s Guide—545799-006

6-5

SDR Configuration and Management Commands

SDR Configuration and Management

Commands

ALTER

Sets or changes global configuration values for SDR. Global parameters are the

default configuration settings for SDR.

parameter-and-value

ACCESSID { USER[ID] | (SU{PER[ID] }

specifies the user ID under which the DDL replication operations are

performed, with the exception of CREATE TABLE or CREATE INDEX

operations (see CREATEID { user-ID | user-name } {, GIVETOUSER }

below).

ALTER [ GLOBAL ] parameter-and-value

parameter-and-value is

{ ACCESS[ID] { USER[ID] | SUPER[ID] }}

{}

{ AUTOCREATECATALOG { ON | OFF }}

{}

{ CREATEID { user-ID | user-name } {, GIVETOUSER }}

{}

{ CREATESECURITY “rwep” }

{}

{ DDLCAPTURE

{ ENABLE[D] | DISABLE[D] | REQUIRE[D] | TEST[ING]}}

{}

{ EMSCOLLECTOR [ $collector ]}

{}

{ KEEPPHYSVOL { ON | OFF } }

{}

{ MARKERFILES { ON | OFF } }

{}

{ NETWORK RDF-control-subvol, primary-node, backup-node}

{}

{ RDFCONFIG { RDF-control-subvol | DEFAULT }

{ AUTO[MATIC] | MANUAL | NOREPL[ICATE] }}

{}

{ RETENTION n { HOURS | DAYS | WEEKS }}

{}

{ UNAUDITEDDDL { OFF | ON } }

{}

{ USERTRAN[SACTION] { ABORT | HOLD | [ASSUME]COMMIT }}

{}

{ UPDATESTAT[ISTICS] { ON | OFF }}