Customer wishes to clear out the messages in the shareplex queues with shareplex shutdown customer is using :
$ qview -i
qview> qsetup <port number>
qview> reset p
qview> exit
Problem with replication - customer wishes to resync and delete messages from queue to avois duplicate postings
In shareplex versions prior to v5 please use the deleteq qview command in place of the reset p
$ qview -i
qview> qsetup <port number>
qview> deleteq p
qview> exit
Truncate the SHAREPLEX_TRANS table before re-starting post.
NOTE: If you forget to truncate the trans table then you will go into false recovery and could get stuck there for a very long time. In this case you need to stop post and truncate SHAREPLEX_TRANS table and then re-start poster
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy