cdr list server

The cdr list server command displays a list of the Enterprise Replication servers that are visible to the server on which the command is run.

Syntax


1  cdr list server?  %Connect Option  (1)? +  server_group
Notes:
Element Purpose Restrictions Syntax
server_group Name of the server group. The database server groups must be defined for Enterprise Replication.

Usage

The cdr list server command displays information about servers. You do not need to be user informix to use this command; any user can run it.

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

When no server-group name is given, the cdr list server command lists all database server groups that are visible to the current replication server.

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

Output Description

The SERVER and ID columns display the name and unique identifier of the Enterprise Replication server group.

The STATE column can have the following values.

Value Description
Active The server is active and replicating data.
Deleted The server has been deleted; it is not capturing or delivering data and the queues are being drained.
Disabled The server is disabled. It is not capturing or delivering data, but its delete tables are being maintained.
Quiescent The server is in the process of being defined.
Suspended Delivery of replication data to the server is suspended.

The STATUS column can have the following values.

Value Description
Connected The connection is active.
Connecting The connection is being established.
Disconnect The connection was explicitly disconnected.
Disconnected will attempt reconnect The connection was disconnected but is being reattempted.
Dropped The connection was disconnected due to a network error because the server is unavailable.
Error The connection was disconnected due to an error (check the log and contact customer support, if necessary).
Failed The connection attempt failed.
Local Identifies that this server is the local server as opposed to a remote server.
Timeout The connection attempt has timed out, but will be reattempted.

The QUEUE column displays the size of the queue for the server group.

The CONNECTION CHANGED column displays the most recent time that the status of the server connection was changed.

Examples

In the following examples, usa, italy, and france are root servers, denver is a nonroot server, and miami is a leaf server. The usa server is the parent of denver, and denver is the parent of miami.
Figure 1: cdr list server example

The surrounding text describes the diagram.

When the cdr list server command includes the name of a database server group, the output displays the attributes of that database server. The following commands and example output illustrate how the cdr list server command displays server information.

In this example, the server g_usa generates ATS and RIS files in XML format, has an idle time out of 15 seconds, and is a hub server.

cdr list server g_usa

NAME      ID     ATTRIBUTES
-----------------------------------------------------
g_usa     1      atsrisformat=xml timeout=15 hub 

In this example, the g_denver server shows the g_usa server as its root server.

cdr list server -c denver g_denver
NAME      ID     ATTRIBUTES
-----------------------------------------------------
g_denver  27     root=g_usa

In this example, the attributes of the g_denver server are shown from the perspective of the italy server. The g_denver server has the g_usa server as its root server and uses the g_usa server to forward replicated transactions between it and the italy server.

cdr list server -c italy g_denver

NAME      ID     ATTRIBUTES
-----------------------------------------------------
g_denver  27     root=g_usa forward=g_usa 

In this example, the g_miami server shows the g_denver server as its root server and that it is a leaf server.

cdr list server g_miami

NAME      ID     ATTRIBUTES
-----------------------------------------------------
g_miami   4      root=g_denver leaf
The following example shows possible output for the cdr list server command if no server groups are specified:
cdr list server 
SERVER         ID STATE    STATUS     QUEUE CONNECTION CHANGED
--------------------------------------------------------------
g_denver       1 Active   Local      0
g_miami        2 Active   Connected  0     Mar 19 13:48:44
g_usa          3 Active   Connected  0     Mar 19 13:48:40
g_france       4 Active   Connected  0     Mar 19 13:48:41
g_italy        5 Active   Connected  0     Mar 19 13:48:45