Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2007
    Posts
    13

    Thumbs up Unanswered: Rep. Server Commands

    This is regarding the Replication Server ver 12.0, running on Solaris 2.7

    We need some help from you to identify Sybase Replication Server commands as follows:

    1. A command to stop Replicantion Server from putting data into a particular route, as the receiving machine on that route is permanently down.
    We used the 'suspend' command, but that only stops the delivery to the replicate site. The data is still inserted in the queue at the primary, and in course of time that queue becomes full and the Replication process (to other sites) comes to a stop.

    2. A command to purge the out bound queue of a particular route, online.
    Currently we bring down the Rep. Server and restart it in Maintenance mode, purge the outbound queue, again bring down the Rep. Server, and then restart it in the normal mode. We want to avoid all this, and also not stop replication on the other routes during this period.

    Thanks and regards
    Goraksh

  2. #2
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    1. The only way to stop Rep Server from pumping data in the stable queue is to either stop the rep agent on the primary, which means your primary transaction log will start to fill up or disable the secondary truncation marker on the primary.

    2. You can purge only transaction in the INBOUND queue, once the DIST processes it cannot be purged. However you can zap blocks in the output queue. Look for zap.

    You are playing with fire when you do these things, be sure to identify the correct blocks and the right queue.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •