cdr list replicateset

The cdr list replicateset command displays information about the replication sets defined on the current server.

Syntax


1  cdr list replicateset?  %Connect Option  (1)? +  repl_set
Notes:
Element Purpose Restrictions Syntax
repl_set Name of the replicate set. The replicate set must exist. Long Identifiers

Usage

The cdr list replicateset command displays a list of the replicate sets that are currently defined. To list the information about each of the replicates within the replicate set, use cdr list replicateset repl_set.

You do not need to be user informix to use this command; any user can run it.

In hierarchical topology, leaf servers have limited information about other database servers in the Enterprise Replication domain. Therefore, when cdr list replicateset is executed against a leaf server, it displays incomplete information about the other database servers.

If you specify the name of a grid replicate set, the command displays the names of the replicates that were automatically created through the grid and any replicates manually added to the grid replicate set. The name of the grid replicate set is the same as the name of the grid.

The cdr list replicateset command can be used while the replication server is in DDRBLOCK mode. Before using the cdr list replicateset command you must set the DBSPACETEMP configuration parameter and create a temporary dbspace with the onspaces utility.

Examples

The following example displays a list of the replicate sets on the current server: 
cdr list replicateset
The following output might result from the previous command: 
Ex T REPLSET                  PARTICIPANTS
-----------------------------------------------
N  Y  g1                         Repl1, Repl4
N  Y  g2                         Repl2, Repl3, Repl5

The Ex field shows whether the replicate set is exclusive. The T field shows whether the replicate set was created from a template.

This example displays information for all the replicates in the replicate set g1: 
cdr list replset g1
The following output might result from the previous command: 
REPLICATE SET:g1 [Exclusive]
CURRENTLY DEFINED REPLICATES
----------------------------------------------------------------------
REPLICATE:     Repl1
STATE:         Inactive
CONFLICT:      Ignore
FREQUENCY:     immediate
QUEUE SIZE:    0
PARTICIPANT:   bank:arthur.account
OPTIONS:       row,ris,ats
REPLTYPE:      Master

REPLICATE:     Repl4
STATE:         Inactive
CONFLICT:      Deletewins
FREQUENCY:     immediate
QUEUE SIZE:    0
PARTICIPANT:   bank:arthur.teller
OPTIONS:       row,ris,ats
REPLTYPE:      Master
The information supplied for each replicate is the same as the information provided by the cdr list replicate command.