|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
![Reply to topic](templates/DAJ_Glass/images/lang_english/reply.gif) |
|
Threshold setting for worklist retrival |
« View previous topic :: View next topic » |
Author |
Message
|
giriplug |
Posted: Thu Jun 30, 2011 10:11 pm Post subject: Threshold setting for worklist retrival |
|
|
Newbie
Joined: 19 Sep 2006 Posts: 3
|
Hi Guys,
Would be a great help to me if anyone out there can let me know if there is a setting in the runtime server to set threshold for number of worlist retrieval via MQ client. I know how to set on the client but i was informed there is also a setting in the server...
Thanks in advance... |
|
Back to top |
|
![](templates/DAJ_Glass/images/spacer.gif) |
hos |
Posted: Fri Jul 01, 2011 12:42 am Post subject: |
|
|
Chevalier
Joined: 03 Feb 2002 Posts: 470
|
Hi,
do you really mean to limit the number of worklists, or do you rather mean the number of workitems within a list?
There exist two different list objects for this, both of them have a threshold property which is honored by the server: worklist-list and workitem-list.
Select the appropriate object and set the threshold value (by API or by a client program). It will work on the server side.
There is no other server setting that could be used for this. |
|
Back to top |
|
![](templates/DAJ_Glass/images/spacer.gif) |
giriplug |
Posted: Wed Jul 06, 2011 10:24 pm Post subject: |
|
|
Newbie
Joined: 19 Sep 2006 Posts: 3
|
Hi,
We would like to get the default threshold for any query that limits the amount of retrieved items from workflow server. Fro eg, the users sets the worklist "Threshold" in workflow cleint is "1000" or max "1300", when user retreive more than 1200 itself they are getting error (FMC_API_ERROR_UNKNOWN:Unknown Error.(817)) |
|
Back to top |
|
![](templates/DAJ_Glass/images/spacer.gif) |
hos |
Posted: Thu Jul 07, 2011 12:47 am Post subject: |
|
|
Chevalier
Joined: 03 Feb 2002 Posts: 470
|
Got it.
Unfortunately there is no answer for your desire.
The query threshold limits the number of items in a list and is directly passed from the MQWF server to the database system.
However there is a different parameter that affects the number of items in a query. The MAXIMUM_QUERY_MESSAGE_SIZE defines the maximum amount of memory that a query result may consume - and this is what causes the RC 817 in your environment.
While you can easily increase the MAXIMUM_QUERY_MESSAGE_SIZE parameter ( see the following thread http://www.mqseries.net/phpBB2/viewtopic.php?t=13080&highlight= ) you should be aware that such big queries heavily affect the overall performance and resource consumption of your system. Nobody can really handle 1000 workitems in his todo list. In reality business applications can run with a threshold that is far below of these limits. If you object I would say that there is something wrong with your process model javascript:emoticon(' ') |
|
Back to top |
|
![](templates/DAJ_Glass/images/spacer.gif) |
|
|
![Reply to topic](templates/DAJ_Glass/images/lang_english/reply.gif) |
|
Page 1 of 1 |
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
|
|
|