The following errors are observed while running “qview –p”:
$ qview -p
que_SHMERR: Shared memory error
A number of reasons can result in this error.
The following workaround can be explored depending on the circumstances:
See if any residual processes exist (applicable if this was run when all processes were supposed to exit due to shutdown of Shareplex) and then run the command again.
Check to see if there are any hung semaphores/shared memory segments and remove them (see Solution # SOL6531 for details) and then run the command again (again, applicable if this was run when all processes were supposed to exit due to shutdown of Shareplex).
If the error consistently shows up when running “qview –p” while Shareplex was shutdown, then try to run it only when Post and Import are stopped and Shareplex is running.
If only Post was stopped and Import was running when “qview –p” was run, then stop Import as well and run the command again to see if this helps. Alternatively, If the error consistently shows up when running “qview –p” while Shareplex was running with Import and Post stopped, then then try to run it only when Shareplex is shutdown. These workaround have helped in the past.
If this is a Windows environment, the user logged in to the Windows system needs to be administrator (either Domain or Local Administrator), not a user with 'administrator' privilege. The command need to be run as:
qview -r<port number> -i
If none of the above help, then contact Support for other workaround including removing such rollbacks manually using qview utility in interactive mode (that is, running qview –i).