ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum IndexWorkflow Engines - IBM MQ Workflow & Business Process ChoreographerThreshold setting for worklist retrival

Post new topicReply to topic
Threshold setting for worklist retrival View previous topic :: View next topic
Author Message
giriplug
PostPosted: Thu Jun 30, 2011 10:11 pm Post subject: Threshold setting for worklist retrival Reply with quote

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
View user's profile Send private message
hos
PostPosted: Fri Jul 01, 2011 12:42 am Post subject: Reply with quote

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
View user's profile Send private message
giriplug
PostPosted: Wed Jul 06, 2011 10:24 pm Post subject: Reply with quote

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
View user's profile Send private message
hos
PostPosted: Thu Jul 07, 2011 12:47 am Post subject: Reply with quote

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
View user's profile Send private message
Display posts from previous:
Post new topicReply to topic Page 1 of 1

MQSeries.net Forum IndexWorkflow Engines - IBM MQ Workflow & Business Process ChoreographerThreshold setting for worklist retrival
Jump to:



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
Protected by Anti-Spam ACP


Theme by Dustin Baccetti
Powered by phpBB 2001, 2002 phpBB Group

Copyright MQSeries.net. All rights reserved.