Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2006
    Location
    Johannesburgh
    Posts
    8

    Unanswered: Urgent Need to know how to use sysadmin sqm_purge_queue

    Hi all

    I have a serious problem
    I have messed up a replication system in a live environment
    I need to purge the queue from repserver to the secondary site
    then I'll need to restore the backups
    I need to know how to use the sysadmin sqm_purge_queue command

  2. #2
    Join Date
    Aug 2006
    Posts
    4
    First set the replication server in hibernation mode by

    sysadmin hibernate_on, <replication_serve_name>
    go

    if this doesn't work out
    shutdown the replication server and modify the start_server file name by adding the -m flag like ASE. This will make the repserver to start in single user mode with dsi threads off.

    After succes with any of the above steps. The run the following command.

    sysadmin sqm_purge_queue, <queue_number>, <queue_type>

    Thanks

  3. #3
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    "rebuild queues" does all the queues at one shot. There are a lot of things you need to worry with rebuild. Best to read the manual

Posting Permissions

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