File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Websphere and the fly likes WebSphere V6.1 Db2 V8.1 Connection Problem Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Products » Websphere
Bookmark "WebSphere V6.1 Db2 V8.1 Connection Problem" Watch "WebSphere V6.1 Db2 V8.1 Connection Problem" New topic

WebSphere V6.1 Db2 V8.1 Connection Problem

mayur shah

Joined: Sep 07, 2007
Posts: 15
Hello Everybody,

I have installed
* Websphere Application Server V6.1 on Red Hat Linux V4
* DB2 V8.1 on another system with Red Hat Linux V5.

I am trying to connect from WAS to the DB2 database.

The error i get is :
java.lang.Exception: java.sql.SQLException: : Error opening socket to server bpa-srv-06/ on port 50000 with message : Aucun chemin d'acc�s pour atteindre l'h�te cible DB2ConnectionCorrelator: nullDSRA0010E: Etat SQL = null, Code d'erreur = -4 499.

Now is what i configured for the jdbc driver :

jdbc path native path variable : DB2UNIVERSAL_JCBC_DRIVER_NATIVEPATH
path : /opt/IBM/WebSphere/AppServer1/lib

was variable to communicate between was & db2 B2UNIVERSAL_JDBC_DRIVER_PATH
path : /opt/IBM/

universal jdbc driver variable : UNIVERSAL_JDBC_DRIVER_PATH
path : /opt/IBM/WebSphere/AppServer1/java

I have installed WebSphere application server :


All the required jar files ie, db2jcc.jar,db2jcc_license_cu.jar
db2jcc_license_cisuz.jar are placed in lib and java folder in /WebSphere/AppServer1 directory

But still i am not able to connect to the DB2 server.

I have also checked the network configuration. I am able to connect to the another server machine , but with was/db2 connection not possible as it gives above error.

any help is appreciated
thanks in advance

I agree. Here's the link:
subject: WebSphere V6.1 Db2 V8.1 Connection Problem
It's not a secret anymore!