cdr list replicate

The cdr list replicate command displays information about the replicates on the current server.

Syntax


1  cdr list replicate?  %Connect Option  (1)
1 brief
1! full
2? +  replicate
Notes:
Element Purpose Restrictions Syntax
replicate Name or ID of the replicates. The replicates must exist. Long Identifiers

Usage

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; any user can run it.

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

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

Output Description

The STATE field can include the following values.

Table 1. Values of the STATE field
Value Description
Active Specifies that Enterprise Replication captures data from the logical log and transmits it to participants
Definition Failed Indicates that the replication definition failed on a peer server
Inactive Specifies that no database changes are captured, transmitted, or processed
Pending Indicates that a cdr delete replicate command ran and the replicate is waiting for acknowledgment from the participants
Quiescent Specifies that no database changes are captured for the replicate or participant
Suspended Specifies that the replicate captures and accumulates database changes but does not transmit any of the captured data

The CONFLICT field can include the following values.

Table 2. Values of the CONFLICT field
Value Description
Deletewins Specifies that the replicate uses the delete wins conflict-resolution rule
Ignore Specifies that the replicate uses the ignore conflict-resolution rule
Timestamp Specifies that the replicate uses the time stamp conflict-resolution rule
Procedure Specifies that the replicate uses an SPL routine as the conflict-resolution rule

The FREQUENCY field can include the following values.

Table 3. Values of the FREQUENCY field
Value Description
immediate Specifies that replication occurs immediately
every hh:mm Specifies that replications occur at intervals (for example, 13:20 specifies every thirteen hours and 20 minutes)
at day.hh:mm Specifies that replications occur at a particular time on a particular day (for example, 15.18:30 specifies on the 15th day of the month at 6:30 P.M.)

The OPTIONS field can include the following values.

Table 4. Values of the OPTIONS field
Value Description
ats Indicates that ATS files are generated if transactions fail to be applied at the target server.
firetrigger Indicates that the rows that this replicate inserts fire triggers at the destination.
floatcanon Indicates that floating-point numbers are replicated in machine-independent decimal representation.
floatieee Indicates that floating-point numbers are replicated in either 32-bit (for SMALLFLOAT) or 64-bit (for FLOAT) IEEE floating-point format.
fullrow Indicates to replicate only changed columns and disable upserts.
ignoredel Indicates that rows are retained if they are deleted on other nodes in the domain.
pendingsync Indicates that the replication server was enabled with the cdr enable server command but that the participant is not yet synchronized with the rest of the domain. ATS and RIS files for this participant are not created if transactions are aborted.
ris Indicates that RIS files are generated if transactions fail to be applied at the target server.
row Indicates that the replicate uses row scope.
transaction Indicates that the replicate uses transaction scope.
UTF8 Indicates that code set conversion between replicates is enabled.
TimeSeries Indicates that the replicate includes a TimeSeries column.
alwaysRepLOBs Indicates that large object columns are always included in replicated rows regardless of whether the large objects changed.

The REPLTYPE field can include the following values. If the REPLTYPE field does not show, the replicate is a classic replicate.

Table 5. Values of the REPLTYPE field
Value Description
Master Indicates that the replicate is defined as a master replicate.
Shadow Indicates that the replicate is a shadow replicate. A shadow replicate can also be a master replicate.
Grid Indicates that the replicate belongs to a grid replicate set.
Sendonly Indicates that the participant only sends data.

The PARENT REPLICATE field shows only for shadow replicates. It shows the name of the replicate on which the shadow replicate is based.

Examples

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

The output from the command shows two replicates: 

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:         Deletewins
FREQUENCY:        immediate
QUEUE SIZE:       0
PARTICIPANT:      bank:joe.account 
OPTIONS:          row,ris,ats
REPLTYPE:         Master,Shadow
PARENT REPLICATE: Repl1

If the replicate belongs to a grid replicate set, the REPLTYPE field includes the value Grid.

CURRENTLY DEFINED REPLICATES
---------------------------------------------
REPLICATE:        grid_6553604_100_3
STATE:            Active ON:g_delhi
CONFLICT:         Always Apply
FREQUENCY:        immediate
QUEUE SIZE:       0
PARTICIPANT:      tdb:nagaraju.t1
OPTIONS:          row,ris,fullrow
REPLID:           6553605 / 0x640005
REPLMODE:         PRIMARY  ON:g_delhi
APPLY-AS:         INFORMIX ON:g_delhi
REPLTYPE:         Master,Grid

The PARENT REPLICATE field only shows 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 command shows the replicates: 
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 output from the command shows information for the replicate: 
REPLICATE   TABLE                              SELECT
----------------------------------------------------------------
Repl1       bank@g_newyork:joe.teller          select * from joe.teller
Repl1       bank@g_sanfrancisco:joe.teller     select * from joe.teller