cdr suspend server

The cdr suspend server command suspends the delivery of replication data to a database server from either a specified list of database servers or from all database servers in the domain.

Syntax

Read syntax diagramSkip visual syntax diagram
>>-cdr suspend server--+--------------------------+------------->
                       |                      (1) |   
                       '-| Connect Option   |-----'   

                    .-----------------------.   
                    V                       |   
>--to_server_group----+-------------------+-+------------------><
                      '-from_server_group-'     

Notes:
  1. See Connect Option.
Element Purpose Restrictions
to_server_group Name of database server group to which to suspend delivery of replication data. The database server group must be currently active in Enterprise Replication.
from_server_group Name of the database server group from which to stop sending data to to_server_group. The database server group must be currently active in Enterprise Replication.

Usage

The cdr suspend server command suspends delivery of replication data to the to_server_group database server from the database servers included in the from_server_group list. If the from_server_group list is omitted, the command suspends replication of data from all database servers participating in the replication domain to the to_server_group.

Suspending replication has the following effects:

  • The connections between the suspended server and active replication servers remain active.
  • Transactions on the suspended replication server are sent to the active replication servers.
  • Transactions on active replication servers are queued for the suspended replication server.
  • Control messages on active replication servers are sent to the suspended replication server.
  • Control messages on the suspended replication server are sent to the active replication servers.

To restart replication on a suspended replication server, run the cdr resume server command. Shutting down and restarting the suspended database server does not resume replication.

When you run the cdr suspend server command, an event alarm with a class ID of 51 is generated, if that event alarm is enabled.

You can run this command from within an SQL statement by using the SQL administration API.

Examples

The following example connects to the default server (the one specified by the INFORMIXSERVER environment variable) and suspends replication of data to the server g_iowa from the servers g_ohio and g_utah:
cdr sus serv g_iowa g_ohio g_utah

Copyright© 2018 HCL Technologies Limited