By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,514 Members | 1,717 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,514 IT Pros & Developers. It's quick & easy.

Timing out while fetching data from DB2

P: 2
Hi,

We are facing following error message with a batch job which is used to fetch data from DB2.The query is executed from Perl script.This job has started failing very frequently now a days.This is the message,

"DBI_ERROR: [IBM][CLI Driver] SQL30081N A communication error has been detected. Communication protocol being used: "TCP/IP". Communication API being used: "SOCKETS". Location where the error was detected: "170.40.27.14". Communication function detecting the error: "recv". Protocol specific error code(s): "10054", "*", "0". SQLSTATE=08001
".

Please advice on this.
Mar 19 '07 #1
Share this Question
Share on Google+
1 Reply


P: 2
We resolved the issue by assigning an index to column in one of the table in DB2 from which we fetch the datas using the query.The index to that column picked the response time to 7-10 mts from 30 mts.

Thanks.
Mar 23 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.