Suspending transaction processing and replication activities

To suspend replication of and transaction activity in the databases:

  1. Verify that subscriptions that are being created by the create subscription command, with primary data in the databases being upgraded, have reached the “valid” state at the primary Replication Server before you begin the upgrade. Use the check subscription command to find the “valid” state.

    Defer the upgrade process while the subscriptions are being created so that Replication Server does not interfere by attempting to access the database being upgraded.

    Make sure that no users create subscriptions for data in the database you are upgrading until the upgrade procedure is finished.

  2. Execute rs_helproute in each Replication Server System Database (RSSD) being upgraded.

    The status of all existing routes should be “Active.” If any routes are not active, resolve them before continuing. See the Replication Server documentation for help in diagnosing and fixing the problem with the route, and then go to step 3.

  3. Shut down all applications that use the databases you are upgrading.

  4. Use the admin who command in Replication Server to find the existing Data Server Interface (DSI) connections to the data server being upgraded.

  5. Suspend all DSI connections to the non-RSSD databases you are upgrading by entering the following command in Replication Server for each database:

    1> suspend connection to dataserver.database
    2> go
    
  6. Leave the DSI connections to the RSSD databases running.