cdr delete replicateset

The cdr delete replicateset command deletes an exclusive or non-exclusive replicate set from the global catalog.

Syntax


1  cdr delete replicateset?  %Connect Option(1) +  repl_set
Notes:
Element Description Restrictions Syntax
repl_set Name of replicate set to delete. Can be the name of a derived replicate set. Long Identifiers

Usage

The cdr delete replicateset command deletes the exclusive or non-exclusive replicate set repl_set from the global catalog.

The cdr delete replicateset command does not affect the replicates or associated data. When a replicate set is deleted, the individual replicates within the replicate set are unchanged.

Attention: Do not delete time-based exclusive replicate sets. Doing so might result in inconsistent data.
Attention: Avoid deleting a replicate set and immediately re-creating it with the same name. If you re-create the objects immediately (before the operation finishes propagating to the other Enterprise Replication database servers in the network), failures might occur in the Enterprise Replication system at the time of the operation or later.
Important: If you are creating a replicate set to replace the one you deleted, use the cdr check queue -qname=ctrlq command to make sure that the delete operation propagated to all the servers.

When you run the cdr delete replicateset command, an event alarm with a class ID of 69 is generated, if that event alarm is enabled.

You can run this command from within an SQL statement by using the SQL administration API.

Example 1: Deleting a single replicate set

The following example connects to the database server specified by the INFORMIXSERVER environment variable and deletes the replicate set accounts_set:
cdr delete replset accounts_set

Example 2: Deleting multiple replicate sets

The following example connects to database server hoek and deletes the replicate sets accounts1_set and accounts2_set:
cdr del replset -c hoek accounts1_set accounts2_set