Solved

db2 connection issues

Posted on 2008-10-31
5
1,154 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 45

Expert Comment

by:Kent Olsen
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:
Kent Olsen 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

MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
PowerView Button Missing From Excel 2013 Pro Plus Insert Tab 7 2,488
Excel object stays open 19 82
Sharepoint to FTP? 3 79
Access 2010 7 34
Lync meeting or Lync conferencing is what many organizations would like to deploy to allow them save money. But companies are now giving up for various reasons, one of which is that they cannot join external meetings (non-federated company meetings)…
The System Center Operations Manager 2012, known as SCOM, is a part of the Microsoft system center product that provides the user with infrastructure monitoring and application performance monitoring. SCOM monitors:   Windows or UNIX/LinuxNetwo…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

735 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