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.
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