
SDR Commands
HP NonStop SQL DDL Replicator User’s Guide—545799-007
6-5
SDR Configuration and Management Commands
SDR Configuration and Management
Commands
ALTER GLOBAL
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 on page 6-6
below).
ALTER [ GLOBAL ] parameter-and-value
parameter-and-value is
{ ACCESSID { USER[ID] | SUPER[ID] } }
{ }
{ AUTOCREATECATALOG { ON | OFF } }
{ }
{ CREATEID { user-ID | user-name } [, GIVETOUSER[ID] ] }
{ }
{ 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 } }
Commentaires sur ces manuels