DB2 Setup in Weblogic5.1/6.1

[Malli Raman]

Hi,

I am using weblogic 5.1/6.1 to access the database (DB2) either locally or remotely.
Initially i am using DB2 installed in the remote System using weblogic6.1/5.1. It was working fine.
Now it is giving error for remote system using COM.ibm.jdbc.db2.net.DB2Driver but to access the DB2 in the local System using COM.ibm.jdbc.db2.app.DB2Driver,it is working fine.
The log file(weblogic5.1) is given below:
In this server i am using DB2Pool for remote DB2 accessing and oraclePool for remote oracle accessing and DB2Pool2 for local DB2 accessing. Please let me know what was the reason for above error and how to solve it.

Thanks & Regards,
M.S.Raman
{refreshMinutes=10, poolName=DB2Pool2, loginDelaySecs=1, testTable=dual, maxCapacity=10, props=user=wcs;password=wcs;, allowShrin
Delaying 1 seconds before making a DB2Pool2 pool connection.
Mon Jan 15 10:29:47 GMT+05:30 2001:<I> <JDBC Pool> Connection for pool "DB2Pool2" created.
Delaying 1 seconds before making a DB2Pool2 pool connection.
Mon Jan 15 10:29:48 GMT+05:30 2001:<I> <JDBC Pool> Connection for pool "DB2Pool2" created.
Delaying 1 seconds before making a DB2Pool2 pool connection.
Mon Jan 15 10:29:49 GMT+05:30 2001:<I> <JDBC Pool> Connection for pool "DB2Pool2" created.
Delaying 1 seconds before making a DB2Pool2 pool connection.
Mon Jan 15 10:29:50 GMT+05:30 2001:<I> <JDBC Pool> Connection for pool "DB2Pool2" created.
Mon Jan 15 10:29:50 GMT+05:30 2001:<I> <JDBC Pool> Creating connection pool DB2Pool with:
{refreshMinutes=10, poolName=DB2Pool, loginDelaySecs=1, testTable=dual, maxCapacity=10, props=user=wcs;password=wcs;, allowShrink
Delaying 1 seconds before making a DB2Pool pool connection.
COM.ibm.db2.jdbc.DB2Exception: [IBM][JDBC Driver] CLI0616E Error opening socket. SQLSTATE=08S01
at COM.ibm.db2.jdbc.net.SQLExceptionGenerator.socketException(SQLExceptionGenerator.java:574)
at COM.ibm.db2.jdbc.net.DB2Connection.create(DB2Connection.java, Compiled Code)
at COM.ibm.db2.jdbc.net.DB2Connection.<init>(DB2Connection.java:205)
at COM.ibm.db2.jdbc.net.DB2Driver.connect(DB2Driver.java:210)
at weblogic.jdbc.common.internal.ConnectionEnvFactory.makeConnection(ConnectionEnvFactory.java:149)
at weblogic.jdbc.common.internal.ConnectionEnvFactory.createResource(ConnectionEnvFactory.java:109)
at weblogic.common.internal.ResourceAllocator.makeResources(ResourceAllocator.java, Compiled Code)
at weblogic.common.internal.ResourceAllocator.<init>(ResourceAllocator.java, Compiled Code)
at weblogic.jdbc.common.internal.ConnectionPool.startup(ConnectionPool.java:330)
at weblogic.jdbc.common.internal.JdbcInfo.initPools(JdbcInfo.java, Compiled Code)
at weblogic.jdbc.common.internal.JdbcInfo.startup(JdbcInfo.java:200)
at weblogic.jdbc.common.internal.JdbcStartup.main(JdbcStartup.java:11)
at java.lang.reflect.Method.invoke(Native Method)
at weblogic.t3.srvr.StartupThread.runMain(StartupThread.java:219)
at weblogic.t3.srvr.StartupThread.doWork(StartupThread.java, Compiled Code)
at weblogic.t3.srvr.PropertyExecuteThread.run(PropertyExecuteThread.java:62)
Mon Jan 15 10:29:56 GMT+05:30 2001:<I> <JDBC Pool> Sleeping in createResource()
Mon Jan 15 10:29:57 GMT+05:30 2001:<E> <JDBC Pool> Failed to create connection pool "DB2Pool"
weblogic.common.ResourceException: weblogic.common.ResourceException:
Could not create pool connection. The DBMS driver exception was:
COM.ibm.db2.jdbc.DB2Exception: [IBM][JDBC Driver] CLI0616E Error opening socket. SQLSTATE=08S01
at COM.ibm.db2.jdbc.net.SQLExceptionGenerator.socketException(SQLExceptionGenerator.java:574)
at COM.ibm.db2.jdbc.net.DB2Connection.create(DB2Connection.java, Compiled Code)
at COM.ibm.db2.jdbc.net.DB2Connection.<init>(DB2Connection.java:205)
at COM.ibm.db2.jdbc.net.DB2Driver.connect(DB2Driver.java:210)
at java.sql.DriverManager.getConnection(DriverManager.java:457)
at java.sql.DriverManager.getConnection(DriverManager.java:137)
at weblogic.jdbc.common.internal.ConnectionEnvFactory.makeConnection(ConnectionEnvFactory.java:172)
at weblogic.jdbc.common.internal.ConnectionEnvFactory.createResource(ConnectionEnvFactory.java:109)
at weblogic.common.internal.ResourceAllocator.makeResources(ResourceAllocator.java, Compiled Code)
at weblogic.common.internal.ResourceAllocator.<init>(ResourceAllocator.java, Compiled Code)
at weblogic.jdbc.common.internal.ConnectionPool.startup(ConnectionPool.java:330)
at weblogic.jdbc.common.internal.JdbcInfo.initPools(JdbcInfo.java, Compiled Code)
at weblogic.jdbc.common.internal.JdbcInfo.startup(JdbcInfo.java:200)
at weblogic.jdbc.common.internal.JdbcStartup.main(JdbcStartup.java:11)
at java.lang.reflect.Method.invoke(Native Method)
at weblogic.t3.srvr.StartupThread.runMain(StartupThread.java:219)
at weblogic.t3.srvr.StartupThread.doWork(StartupThread.java, Compiled Code)
at weblogic.t3.srvr.PropertyExecuteThread.run(PropertyExecuteThread.java:62)
at weblogic.jdbc.common.internal.ConnectionEnvFactory.makeConnection(ConnectionEnvFactory.java:182)
at weblogic.jdbc.common.internal.ConnectionEnvFactory.createResource(ConnectionEnvFactory.java:109)
at weblogic.common.internal.ResourceAllocator.makeResources(ResourceAllocator.java, Compiled Code)
at weblogic.common.internal.ResourceAllocator.<init>(ResourceAllocator.java, Compiled Code)
at weblogic.jdbc.common.internal.ConnectionPool.startup(ConnectionPool.java:330)
at weblogic.jdbc.common.internal.JdbcInfo.initPools(JdbcInfo.java, Compiled Code)
at weblogic.jdbc.common.internal.JdbcInfo.startup(JdbcInfo.java:200)
at weblogic.jdbc.common.internal.JdbcStartup.main(JdbcStartup.java:11)
at java.lang.reflect.Method.invoke(Native Method)
at weblogic.t3.srvr.StartupThread.runMain(StartupThread.java:219)
at weblogic.t3.srvr.StartupThread.doWork(StartupThread.java, Compiled Code)
at weblogic.t3.srvr.PropertyExecuteThread.run(PropertyExecuteThread.java:62)
at weblogic.jdbc.common.internal.ConnectionEnvFactory.createResource(ConnectionEnvFactory.java:125)
at weblogic.common.internal.ResourceAllocator.makeResources(ResourceAllocator.java, Compiled Code)
at weblogic.common.internal.ResourceAllocator.<init>(ResourceAllocator.java, Compiled Code)
at weblogic.jdbc.common.internal.ConnectionPool.startup(ConnectionPool.java:330)
at weblogic.jdbc.common.internal.JdbcInfo.initPools(JdbcInfo.java, Compiled Code)
at weblogic.jdbc.common.internal.JdbcInfo.startup(JdbcInfo.java:200)
at weblogic.jdbc.common.internal.JdbcStartup.main(JdbcStartup.java:11)
at java.lang.reflect.Method.invoke(Native Method)
at weblogic.t3.srvr.StartupThread.runMain(StartupThread.java:219)
at weblogic.t3.srvr.StartupThread.doWork(StartupThread.java, Compiled Code)
at weblogic.t3.srvr.PropertyExecuteThread.run(PropertyExecuteThread.java:62)
Mon Jan 15 10:29:57 GMT+05:30 2001:<I> <JDBC Pool> Creating connection pool oraclePool with:
{refreshMinutes=10, poolName=oraclePool, loginDelaySecs=1, testTable=dual, maxCapacity=10, props=user=SCOTT;password=tiger;, allo
Delaying 1 seconds before making a oraclePool pool connection.
Mon Jan 15 10:29:59 GMT+05:30 2001:<I> <JDBC Pool> Connection for pool "oraclePool" created.
Delaying 1 seconds before making a oraclePool pool connection.
Mon Jan 15 10:30:00 GMT+05:30 2001:<I> <JDBC Pool> Connection for pool "oraclePool" created.
Delaying 1 seconds before making a oraclePool pool connection.
Mon Jan 15 10:30:05 GMT+05:30 2001:<I> <JDBC Pool> Connection for pool "oraclePool" created.
Delaying 1 seconds before making a oraclePool pool connection.
Mon Jan 15 10:30:06 GMT+05:30 2001:<I> <JDBC Pool> Connection for pool "oraclePool" created.
Mon Jan 15 10:30:10 GMT+05:30 2001:<I> <JMS> Beginning startup process
Mon Jan 15 10:30:10 GMT+05:30 2001:<I> <JMS> Init JMS Security
Mon Jan 15 10:30:10 GMT+05:30 2001:<I> <JMS> Initializing from weblogic.properties
Mon Jan 15 10:30:10 GMT+05:30 2001:<I> <JMS> Startup process complete. JMS is active
Mon Jan 15 10:30:10 GMT+05:30 2001:<I> <JMS> Bound SessionPoolManager as weblogic.jms.SessionPoolManager
Mon Jan 15 10:30:10 GMT+05:30 2001:<I> <JMS> Bound ConnectionConsumerManager as weblogic.jms.ConnectionConsumerManager
Mon Jan 15 10:30:10 GMT+05:30 2001:<I> <WebLogicServer> Invoking main-style startup RMI Registry weblogic.rmi.internal.RegistryIm
Mon Jan 15 10:30:10 GMT+05:30 2001:<I> <RMI> Registry started
Mon Jan 15 10:30:10 GMT+05:30 2001:<I> <EJB> 0 EJB jar files loaded, containing 0 EJBs
Mon Jan 15 10:30:10 GMT+05:30 2001:<I> <EJB> 0 deployed, 0 failed to deploy.
Mon Jan 15 10:30:10 GMT+05:30 2001:<I> <ZAC> ZAC ACLs initialized
Mon Jan 15 10:30:10 GMT+05:30 2001:<I> <ZAC> ZAC packages stored in local directory exports
Mon Jan 15 10:30:10 GMT+05:30 2001:<I> <ListenThread> Listening on port: 7001
<NT Performance Pack> NATIVE: created IoCompletionPort successfully. IoPort=0x000001e4
Mon Jan 15 10:30:10 GMT+05:30 2001:<I> <SSLListenThread> Listening on port: 7002
Mon Jan 15 10:30:11 GMT+05:30 2001:<I> <WebLogicServer> WebLogic Server started

[Malli Raman]

Hi,
I want to add one more thing to the above query:
If i access the (remote) database using DB2 command line processor, I am getting the following error.
Regards,
M.S.Raman.
db2 => connect to demomall user wcs
Enter current password for wcs:
SQL30081N A communication error has been detected. Communication protocol
being used: "TCP/IP". Communication API being used: "SOCKETS". Location
where the error was detected: "". Communication function detecting the error:
"connect". Protocol specific error code(s): "10061", "*", "*".
SQLSTATE=08001

[Milind V. Kulkarni]

Hi,
The problem seems to be related to the setting up of DB2 and not related to configuring JDBC connection.
Regards,
Milind

[Malli Raman]

But in the remote System the db2 is working fine.
Regards,
M.S.Raman.

Originally posted by Milind V. Kulkarni:
Hi,
The problem seems to be related to the setting up of DB2 and not related to configuring JDBC connection.
Regards,
Milind

[Takeshi Toyohara]

hey,
you may have already done this, but i think i had a similar problem before and it took me forever to figure out that i needed to start up the "db2java" process in DB2 to accept incoming jdbc connections.
give it a shot if you havent yet...
t