| Author |
Message
|
| mkhadse |
 Posted: Sat Feb 14, 2004 6:34 pm Post subject: Timeout in query workitems |
 |
|
Acolyte
Joined: 31 Dec 1969
Posts: 73
|
Hi,
I am able to logon but after that I am getting a timeout on query workitems. There are no errors in the error/system log of the workflo configuration.
DB2 log shows: Maxpinnedpages, max pages are in the buffer, performance may not be optimal.
Any ideas on the reason for this?
Thanks |
|
| Back to top |
|
 |
| Ratan |
| Posted: Mon Feb 16, 2004 8:26 am Post subject: |
|
|
Grand Master
Joined: 18 Jul 2002
Posts: 1245
|
How many workitems are there? I remember getting this error when there were too many workitems. I used threshold to solve it.
_________________
-Ratan |
|
| Back to top |
|
|
| mkhadse |
| Posted: Tue Feb 17, 2004 9:45 am Post subject: |
|
|
Acolyte
Joined: 31 Dec 1969
Posts: 73
|
Hi,
The threshold was set to 100. I changed it to 10 and retested. But I am getting the same error in db2 logs.
Here is the error from db2 log:
| Code: |
2004-02-13-18.12.33.267845 Instance:xxx Node:000
PID:18266(db2agent (FMCDB)) Appid:*LOCAL.xxx.040214001233
buffer_pool_services sqlbIsContInRange Probe:541 Database:FMCDB
sqlbKeepPagesPinned: max fixed pages hit, performance may not be optimal!
0000 0000 .... |
Has anybody come across such problem?
Thanks |
|
| Back to top |
|
|
| mzg |
| Posted: Thu Feb 19, 2004 12:59 am Post subject: Check some DB2 settings |
|
|
Newbie
Joined: 01 Oct 2003
Posts: 8
|
it might be that you're running low on page cleaners or something else in that area.
Try to lower the ?chngpgs_thresh parameter, and/or increase the number of pagecleaners and/or increase the size of your bufferpool(s).
_________________
Cheers,
Richard.
-----------------------
IBM Websphere MQ Workflow & Process Choreographer Performance Focal Point |
|
| Back to top |
|
|
| MaheshPN |
| Posted: Wed Apr 21, 2004 7:21 am Post subject: |
|
|
Master
Joined: 21 May 2003
Posts: 245
Location: Charlotte, NC
|
Hi Guys,
I am facing the timeou,t when I tried to pull 8000 workitems. I went through DB2 logs and did db2 reorg and binding. Nothing helped much.
My setup uses client concentrator and if I try connecting to WF server using the servers channel table, I could able to query in 7 sec. But when i try to query connecting to client concentrator QM, it times out after 30sec.
I did bumbed up the channels, queues and qm maxmsgl to 25mb so that it can handle large chunk of messages.
Any other thoughts how we can handle this?
Ps: cluster sender and receiver channels are workin fine as I can do fmcautil and will return records if i use threshold in the query.
Thanks in advance
-Mahesh
IBM Certified Solution expert - MQWorkflow |
|
| Back to top |
|
|
| manoj |
| Posted: Wed Apr 21, 2004 9:08 am Post subject: |
|
|
Master
Joined: 30 Jan 2002
Posts: 237
Location: Virgina
|
I remeber there was some issues with MQ Worklfow get work APIs (libraries) on Sun Solaris Box.. But i am not sure whether it was for 3.3.0 or 3.3.2...
Check the APARs and fix packs and see if you could find
_________________
-manoj |
|
| Back to top |
|
|
| MaheshPN |
| Posted: Thu Apr 22, 2004 8:18 am Post subject: |
|
|
Master
Joined: 21 May 2003
Posts: 245
Location: Charlotte, NC
|
I am using Workflow 3.4 service pack 4. Not aware of any APAR on that.
Thanks
-Mahesh |
|
| Back to top |
|
|
|
|
