cdr delete replicateset
The cdr delete replicateset command deletes an exclusive or non-exclusive replicate set from the global catalog.
Syntax
Notes:
- 1 See Connect Option.
| 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_setExample 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