At times when the "qview -p" command is issued to read release rollback from Post queue It takes a long tome to come back to the command prompt. Customers may want to monitor its progress to know if it is doing anything.
The command qview -p may sometimes take a longer time thereby requiring monitoring. At times it takes a long time to finish releasing a large rollback, depending on the size of the Post queue.
Though the command should eventually finish, one can monitor the progress by issuing qstatus command. Since the OS prompt does not return till the command finishes, open another sp_ctrl session and issue the qstatus command. The backlog in the queue for which "qview -p" was issued would keep reducing with subsequent issuance of "qview -p" and this gives an idea of how far the process is from the finish line. The command should exit gracefully when the rollback is released..
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center