Slow posting for JMS queue (4301503)

Slow posting for JMS queue

Posting is slow for messaging queue.

The SP_OPX_READRELEASE_INTERVAL for JMS queue is set to a very low value. This results frequent checkpointing when applying messages to JMS and high overhead.

1. Execute the following command to see what SP_OPX_READRELEASE_INTERVAL is set to

sp_ctrl>list param all open

2. If it is set to a low value such as 1, set it to default of 100 or higher

sp_ctrl>set parameter SP_OPX_READRELEASE_INTERVAL 100

3. Restart post

Most likely the parameter was set to 1 during some troubleshooting in the past and it was not reset back to the setting which existed before the debugging was started. To know the settings for the various OPX parameters, issue the following command on sp_ctrl: sp_ctrl>list param all open Please be aware that there can be many other reasons for the posting to be slow in an open Post environment and this is just a specific scenario. The parameter is akin to the Post parameter SP_OPO_READRELEASE_INTERVAL for Shareplex for Oracle.