| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| DB2 client connection error CLI0120E |
« View previous topic :: View next topic » |
| Author |
Message
|
| fitzcaraldo |
 Posted: Thu May 20, 2004 8:07 pm Post subject: DB2 client connection error CLI0120E |
 |
|
Voyager
Joined: 05 May 2003
Posts: 98
|
Environment: WMQI 2.1 CSD5, AIX, DB2 v8.1 FP3
Hello,
We have a simple flow that inserts messages, lots of them, into a database table.
We have a broker that runs just this one flow and we run 2 additional instances of the flow to keep up.
Periodically we get the following error in the syslog:
BIP2322E: Database error: SQL State 'HY001'; Native Error Code '-99999'; Error Text '[IBM][CLI Driver] CLI0120E Memory allocation failure. SQLSTATE=HY001'
The broker is using a TCP connection to the database.
The problem only really happens under load (>500,000 messages waiting in the queue)
Most of the references to this message on Google suggest changes/fixpaks to the application using the DB2 client rather than the client itself.
Has anyone seen this before? |
|
| Back to top |
|
 |
| waugh |
| Posted: Fri May 21, 2004 5:12 am Post subject: |
|
|
Master
Joined: 19 Feb 2004
Posts: 225
|
just as a safety measure,
did u change the heap size that fits the bill for broker? If not please refer to configuration guide and give it a try. |
|
| Back to top |
|
|
| fitzcaraldo |
| Posted: Sun May 23, 2004 8:37 pm Post subject: |
|
|
Voyager
Joined: 05 May 2003
Posts: 98
|
Heap sizes set as follows:
DBHEAP =8000
UTIL_HEAP_SZ =10000
GROUPHEAP_RATIO =70
APP_CTL_HEAP_SZ =2048
SORTHEAP =10000
STMTHEAP =20480
APPLHEAPSZ =1000
STAT_HEAP_SZ =10000 |
|
| Back to top |
|
|
| pskmq |
| Posted: Mon Jun 14, 2004 5:31 pm Post subject: |
|
|
Newbie
Joined: 01 Jun 2004
Posts: 2
|
| Did you find any solution for this problem? Currently we are also facing the same problem and looking for solution. Appreciate if you could provide any updates on the problem. |
|
| Back to top |
|
|
|
|
|
| |
|
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
|
|
|
|
