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 Index » WebSphere Message Broker (ACE) Support » No More handles error

Post new topic  Reply to topic
 No More handles error « View previous topic :: View next topic » 
Author Message
keenlearner
PostPosted: Thu Dec 29, 2011 7:10 am    Post subject: No More handles error Reply with quote

Acolyte

Joined: 24 Aug 2006
Posts: 62
Hi Gurus,

I am getting below error from our MB 6.1.0.7 environment on AIX server.
Error Message : "2322 Child SQL exception. HY014. -99999. [IBM][CLI Driver] CLI0129E No more handles. SQLSTATE=HY014".

Flow description:
Flow tries to keep two DB's at sync at real time. The two DBs are IBM iSeries DB2.The Source DB program sends a XML messages with couple of ID's. Our flow goes to the DB and extract the data and loads into Target DB. The flow runs good and working for most of the transactions except current one which errors out with above error message. We analysed the transaction and it has many number if rows to be transformed.
We are using the passthru for insert and update statements and each insert and update is followed by a commit in passthru.

I have also searched the forum for the similar errors but could not find much of the help.

Is there any settings on OBDC connection which can increase the number of handles.

Any help is appreciated.

Thanks
Back to top
View user's profile Send private message
Vitor
PostPosted: Thu Dec 29, 2011 7:16 am    Post subject: Re: No More handles error Reply with quote

Grand High Poobah

Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
keenlearner wrote:
Is there any settings on OBDC connection which can increase the number of handles.


I'd be more interested to know why the flow is consuming so many handles.

Or what your DBA has to say about this.
_________________
Honesty is the best policy.
Insanity is the best defence.
Back to top
View user's profile Send private message
keenlearner
PostPosted: Thu Dec 29, 2011 7:29 am    Post subject: Reply with quote

Acolyte

Joined: 24 Aug 2006
Posts: 62
At the beginning of our code we have something as below

Code:
DECLARE EXIT HANDLER FOR SQLSTATE LIKE '%'


does this cause any issue.

I had a DBA looked into this and he said he see only on active connection on it. So not so much help from their side. I am not able to pin point where exactly the issue lies. Is it on Message Broker side or the DB side.

Thanks
Back to top
View user's profile Send private message
keenlearner
PostPosted: Thu Dec 29, 2011 9:12 am    Post subject: Reply with quote

Acolyte

Joined: 24 Aug 2006
Posts: 62
I was going through the forums and found that each passthru opens a new handler for itself. Is it a true statement or I am lost somewhere.

Thanks
Back to top
View user's profile Send private message
keenlearner
PostPosted: Fri Jan 06, 2012 1:16 pm    Post subject: Reply with quote

Acolyte

Joined: 24 Aug 2006
Posts: 62
I tried to use iSeries Access ODBC Driver and got a success this time.

So some questions
Is it advisable to use iSeries Access ODBC Driver from Message Broker ?
What are the changes we can expect in behaviour ?


Any help appreciated.

Thanks
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » No More handles error
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.