| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| No more handles error |
« View previous topic :: View next topic » |
| Author |
Message
|
| sachinramesh |
 Posted: Wed Jul 23, 2008 12:00 am Post subject: No more handles error |
 |
|
Disciple
Joined: 20 Feb 2007
Posts: 170
|
Hi All
I had a problem while i am processing huge records in MB.
My scenario is i am putting an input file which consists of more than 9000 records and MB need to process those records.In my code i am doing some database transactions .
while doing so i am getting an error saying
[IBM][CLI Driver] CLI0129E No more handles. SQLSTATE=HY014
i want to know whether is there any limit(file size) for Mb to process it,or is therer any other reason which can cause this error.
Can anybody tell me when do we get this error. |
|
| Back to top |
|
 |
| mqpaul |
| Posted: Wed Jul 23, 2008 1:11 am Post subject: That's an SQL message from your database |
|
|
Acolyte
Joined: 14 Jan 2008
Posts: 66
Location: Hursley, UK
|
It's not a message from the broker file processing. At a guess, your flow is leaking database connections. If you are doing your own database work in a JavaCompute node, check that you're closing your connections. If not, check that you have sufficient connections configured for the number of concurrent requests - such as additional flow instances, or other flows accessing the database.
_________________
Paul |
|
| Back to top |
|
|
| sachinramesh |
| Posted: Wed Jul 23, 2008 2:50 am Post subject: Re: That's an SQL message from your database |
|
|
Disciple
Joined: 20 Feb 2007
Posts: 170
|
| mqpaul wrote: |
| It's not a message from the broker file processing. At a guess, your flow is leaking database connections. If you are doing your own database work in a JavaCompute node, check that you're closing your connections. If not, check that you have sufficient connections configured for the number of concurrent requests - such as additional flow instances, or other flows accessing the database. |
Hi mqpaul,
What do u mean by database connection leakage,I am not using java compute node here.i am doing all my transactions in the compute node.
How do i close the database connection in the compute node(esql).
Please let me know i am facing a lot of problem with this error. |
|
| Back to top |
|
|
| mqpaul |
| Posted: Wed Jul 23, 2008 3:51 am Post subject: Sorry, I'm not an expert on SQL and Compute nodes. |
|
|
Acolyte
Joined: 14 Jan 2008
Posts: 66
Location: Hursley, UK
|
If it were Java, you'd be getting connections from a factory, and the leak would be failing to close them before returning. But I don't know if there's a corresponding situation using ESQL and databases.
_________________
Paul |
|
| Back to top |
|
|
| AkankshA |
| Posted: Wed Jul 23, 2008 3:59 am Post subject: |
|
|
Grand Master
Joined: 12 Jan 2006
Posts: 1494
Location: Singapore
|
I faced somewhat similiar issues some time back in V5....
and found that the problem was from Db side... my DBA had resolved that
Did u chk with your DBA ??
Are you able to do SQLPLUS to DB when the flow is deployed..
_________________
Cheers |
|
| Back to top |
|
|
| mqpaul |
| Posted: Wed Jul 23, 2008 8:35 am Post subject: sachinramesh, can you tell us about your broker flow? |
|
|
Acolyte
Joined: 14 Jan 2008
Posts: 66
Location: Hursley, UK
|
If you're processing each of 9000 records in the same transaction, the broker might need to keep 9000 connections, and that could cause your problem. If you are processing them in 9000 separate transactions, each with one record, then the broker should reclaim the connections and then not run out. Which of these alternatives apply depends on how your flow works.
Can you tell us a bit about the flow nodes, their properties and their connections please? And also, as AkankshA says, it may be worth checking with your database administrator. If your database (DB2, I think, from your error message) has too few connections configured, you will hit this problem.
_________________
Paul |
|
| 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
|
|
|
|
