Failed to establish connection:jdbc:db2// due to the following SQL exception: IO exception opening socket to server on port 50000

Posted on 2007-10-15
Last Modified: 2013-11-23
Users trying to log on to the database periodically get this error and after rebooting their systems a few times they are able to connect. Once they are able to connect everything seems to work fine.
Question by:irtekaz
    LVL 92

    Accepted Solution

    sounds like your not closing connections, check that your closing all connections

    Author Comment

    There are several users possibly more than a hundred that logon to the database. So if I understand what you are saying. There are limited number of connections that can be open at one time and since users aren't closing their connections, thats causing the server to reject any new connections?
    LVL 92

    Expert Comment


    Author Comment

    Ok thanks. I will have to speak with my application developers and find out how many concurrent connections the server allows. Thanks a lot for your help.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    Java 1603 Error 2 28
    seriesUp challenge 7 83
    wordsWithout 49 64
    Fibonacci challenge 11 62
    Go is an acronym of golang, is a programming language developed Google in 2007. Go is a new language that is mostly in the C family, with significant input from Pascal/Modula/Oberon family. Hence Go arisen as low-level language with fast compilation…
    Java functions are among the best things for programmers to work with as Java sites can be very easy to read and prepare. Java especially simplifies many processes in the coding industry as it helps integrate many forms of technology and different d…
    Viewers learn about the scanner class in this video and are introduced to receiving user input for their programs. Additionally, objects, conditional statements, and loops are used to help reinforce the concepts. Introduce Scanner class: Importing…
    This tutorial covers a practical example of lazy loading technique and early loading technique in a Singleton Design Pattern.

    745 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

    18 Experts available now in Live!

    Get 1:1 Help Now