Sdr configuration and management commands, Alter, On. see the description of – HP NonStop G-Series User Manual
Page 69: Sdr configuration and management commands 6-5, Alter 6-5, Using the
SDR Commands
HP NonStop SQL DDL Replicator User’s Guide —545799-005
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).
Setting the global ACCESSID to USER[ID] instructs the SDR updater to use
the same user ID to perform the DDL operation on the backup as was used to
perform the DDL operation on the primary system.
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 }
}
{
}
{ 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 }
}