When attempting to stop a named Post process, the process does not stop although the sp_ctrl prompt returns without any error.
1. The qstatus shows the name of the Post queue which in this case is QUEUE1:
sp_ctrl (server_name:port_num)> qstatus
Queues Statistics for server_name
Name: QUEUE1 (o.source_SID-o.target_SID) (MTPost queue)
Number of messages: 0 (Age 0 min; Size 0 mb)
Backlog (messages): 0 (Age 0 min)
2. The command to stop the named post queue is issued:
sp_ctrl (server_name:port_num)> stop post queue queue1
3. However, the Post process is still running.
Incorrect queue name is specified as the queue name is case sensitive.
The command "stop post queue <queuename>" is case sensitive. Most commands of Shareplex are not case sensitive and one can use the lower or upper case interchangeably. But the command to stop post is case sensitive, as are some other commands. To stop the Post process associated with the queue in question, one needs to specify the case correctly as below:
sp_ctrl (server_name:port_num)> stop post queue QUEUE1
sp_ctrl (server_name:port_num)> status
Brief Status for server_name
Process State PID Running Since
--------------- ------------------------------ -------- --------------------
Cop Running 13742 09-Jan-09 21:42:48
Cmd & Ctrl Running 13744 09-Jan-09 21:42:49
Import Running 13745 09-Jan-09 21:42:51
MTPost Stopped by user
There are no active configuration files
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center