Sdr configuration and management commands, Alter, Sdr configuration and management commands 6-5 – HP Integrity NonStop H-Series User Manual
Page 69: Alter 6-5, Using the
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 }}