.-full--.
>>-cdr list replicate--+-------------------------+--+-------+--->
                       |                    (1)  |  '-brief-'
                       '-| Connect Option |------'
 
   .---------------.
   V               |
>----+-----------+-+-------------------------------------------><
     '-replicate-'
 

1. See page Connect Option.

The cdr list replicate command displays information about replicates (the full option). If no replicates are named, the command lists all replicates on the current server. If one or more replicates are named, the command displays detailed information about those replicates.

To display only replicate names and participant information, use the brief option.

You do not need to be user informix to use this command.

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

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

The following example displays a list of the replicates on the current server with full details:

cdr list replicate

The output from the previous command might be the following:

CURRENTLY DEFINED REPLICATES
---------------------------------------------
REPLICATE:        Repl1
STATE:            Inactive
CONFLICT:         Ignore
FREQUENCY:        immediate
QUEUE SIZE:       0
PARTICIPANT:      bank:joe.teller
OPTIONS:          row,ris,ats
REPLTYPE:         Master

REPLICATE:        Repl2
STATE:            Inactive
CONFLICT:         Ignore
FREQUENCY:        immediate
QUEUE SIZE:       0
PARTICIPANT:      bank:joe.account 
OPTIONS:          row,ris,ats
REPLTYPE:         Master,Shadow
PARENT REPLICATE: Repl1

The PARENT REPLICATE field only appears if the replicate is a shadow replicate.

The following example displays a list of the replicates on the current server with brief details:

cdr list replicate brief

The output from the previous command might be the following:

REPLICATE   TABLE                              SELECT
----------------------------------------------------------------
Repl1       bank@g_newyork:joe.teller          select * from joe.teller
Repl1       bank@g_sanfrancisco:joe.teller     select * from joe.teller
Repl2       bank@g_portland:joe.teller         select * from joe.teller
Repl2       bank@g_atlanta:joe.teller          select * from joe.teller

The following example specifies the names of replicate:

cdr list repl brief Repl1

The following output might result from the previous command:

REPLICATE   TABLE                              SELECT
----------------------------------------------------------------
Repl1       bank@g_newyork:joe.teller          select * from joe.teller
Repl1       bank@g_sanfrancisco:joe.teller     select * from joe.teller