Solved

db2 connection issues

Posted on 2008-10-31
5
1,120 Views
Last Modified: 2010-08-05
I have recently inherited a .NET application and for one of the screens it connects with a db2 system.

However, sporadically I get the following error while trying to open a connection to the db2 system. I am a .net professional and know very little about the db2 system. I need to know what steps need to be taken to identify the problem and the possible solution {again this happens sporadically} and I need to let the client know what steps need to be taken to address this issue.

------------------------------------------------------------------------------------
IBM.Data.DB2.DB2Exception Exception Occured
ERROR [08001] [IBM] SQL30081N A communication error has been detected. Communication protocol being used: "TCP/IP". Communication API being used: "SOCKETS". Location where the error was detected: "172.16.1.240". Communication function detecting the error: "connect". Protocol specific error code(s): "10061", "*", "*". SQLSTATE=08001
IBM.Data.DB2
381
at IBM.Data.DB2.DB2ConnPool.d.a(String A_0, Int32 A_1, IsolationLevel A_2, DB2Connection A_3) at IBM.Data.DB2.DB2ConnPool.a(DB2Connection A_0, String A_1, a& A_2, Object& A_3) at IBM.Data.DB2.DB2Connection.Open() at RRB.ERSNet.BLL.DistrictOffice.GetDOInformation(Int32 doNumber) in C:\Working Copy ERSNet\ERSNet\App_Code\BLL\DistrictOffice.vb:line 97
Void a(System.String, Int32, System.Data.IsolationLevel, IBM.Data.DB2.DB2Connection)

thanks
0
Comment
Question by:sanagarwl
  • 2
  • 2
5 Comments
 
LVL 45

Expert Comment

by:Kdo
ID: 22850369
Hi sanagrawl,

The 10061 error code is sent to the client when the server refuses the connection. That suggests that the client is configured properly and reaching the server, but the server has chosen to not accept the connection.

What version of DB2 are you running? The connection limit may be set too low to meet your needs.



Kent
0
 

Author Comment

by:sanagarwl
ID: 22850512
Kent:

Thanks for your response, I'll be speaking with the dba to find out what the connection limit is.

I have no idea the version of DB2 that is running -- last week itself started consulting on a existing .net proj. that makes calls to the db2 backend for one of the pages.

Is there a checklist of possible items that the db2 dba can look at when this error occurs {thought I could run those by her while I'm there...}

Again, thank you very much for your response.

 
0
 
LVL 45

Accepted Solution

by:
Kdo earned 500 total points
ID: 22850630
I'm assuming that you're running DB2 for LUW, and not for Z/OS or the AS/400.

Connection control has changed between the versions so the exact item to check "will depend".

Still, the parameter(s) lie somewhere in the dbm configuration.  You can get all of the tunable parameters with:

  db2 get dbm cfg


Kent
0
 
LVL 5

Expert Comment

by:TheVeee
ID: 22850722
Most of the time I have found that its usually a timeout just because your waiting on a resource of some kind.  Most of the time I have seen this do to pulling too much stuff back so a filter needs to be added to limit the scope of the information returned or also it could be due to time on locking is a page level which makes your query wait for that page of data to be available also.   Could also be the thread limit as mentioned above.

Best thing to do is do what your doing, get your DBA involved to check the logs to see whats going on.  Next if that doesnt work is to put some tracing on and look at that both from your side and also on the DB2 side.
0
 

Author Closing Comment

by:sanagarwl
ID: 31512045
Kent:
Though my specific issue has not been resolved, the orginal intent of the question (which was to identify possible steps for resolving the issue) has been answered. I have scheduled a meeting with the db2 dba and hopefully this should help in resolving the issue.

Will post additional questions as and when issues come up once I have spoken with the db2 dba.

thanks for your help.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Problem to refer to cell 8 81
Azure Remote Apps and an Access program 5 68
encryption on machine 7 80
How can I get a list of all SharePoint document libraries using UI? 5 32
As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
The new Microsoft OS looks great, is easier than ever to upgrade to, it is even free.  So what's the catch?  If you don't change the privacy settings, Microsoft will, in accordance with the (EULA) you clicked okay to without reading, collect all the…
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now