There is corruption in one of a few large queues.
"Fixup all" normally will fix corruption in all queues. However, if all queues are very large, fixup all can take a few hours to finish. If an individual corrupted queue can be identified, qfixup can be used to fix just one corrupted queue. Here are steps:
1. sp_ctrl> stop post
2. sp_ctrl> import
3. proddir/bin>./qview -i
4. qview> qinit
5. qview> qfixup <queue name>
If there are more corrupted queues, just repeat step 5 with a different queue name.
6. qview> exit
7. proddir/bin> ./sp_ctrl
8. sp_ctrl> start post
9. sp_ctrl> start import
Now the qfixup should have fixed corruption if the queues were still fixable. Otherwise, other method such as reset queue or deleteq can be considered accordingly with some data lost.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center