Win a copy of TDD for a Shopping Website LiveProject this week in the Testing forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Paul Clapham
  • Ron McLeod
  • Jeanne Boyarsky
  • Tim Cooke
Sheriffs:
  • Liutauras Vilda
  • paul wheaton
  • Henry Wong
Saloon Keepers:
  • Tim Moores
  • Tim Holloway
  • Stephan van Hulst
  • Carey Brown
  • Frits Walraven
Bartenders:
  • Piet Souris
  • Himai Minh

WebSphere V6.1 Db2 V8.1 Connection Problem

 
Greenhorn
Posts: 15
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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: java.net.NoRouteToHostException : Error opening socket to server bpa-srv-06/192.168.4.245 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 :

/opt/IBM/WebSphere/AppServer1

All the required jar files ie db2java.zip, 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

mnr
 
Did Steve tell you that? Fuh - Steve. Just look at this tiny ad:
Free, earth friendly heat - from the CodeRanch trailboss
https://www.kickstarter.com/projects/paulwheaton/free-heat
reply
    Bookmark Topic Watch Topic
  • New Topic