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