Problem in DB2 Connection by JDBC Adapter.

, ,
1

I am using
 Operating system - Windows XP SP-2
Databse - DB2 UDB 8.1
webMethods - 6.1

I have copied these two jar files db2jcc.jar & db2jcc_license_cu.jar into following path:-
[COLOR=blue]C:\Program Files\webMethods61\IntegrationServer\lib\jars[/color]

MYJDBC:MYCON Details:-

Connection _____________JDBC Adapter Connection
Package________________DB2

Connection Properties:-

Transaction Type ________NO_TRANSACTION
DataSource Class ________com.ibm.db2.jcc.DB2SimpleDataSource
serverName _____________localhost
user ___________________db2admin
password _______________******
databaseName __________WMDB2
portNumber _____________6789
networkProtocol _________tcp
Other Properties _________driverType=2

Connection Management Properties:-

Enable Connection Pooling __true
Minimum Pool Size ________0
Maximum Pool Size ________10
Pool Increment Size _______1
Block Timeout ____________1000
Expire Timeout ___________1000
Startup Retry Count _______0
Startup Backoff Timeout ____10


Error encountered
[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource IBM: DB2JDBC.
[ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.
[ADA.1.204] Cannot connect to the database with DataSource class “com.ibm.db2.jcc.DB2SimpleDataSource”.
SQL30081N A communication error has been detected. Communication protocol being used: “TCP/IP”. Communication API being used: “SOCKETS”. Location where the error was detected: “192.168.1.100”. Communication function detecting the error: “recv”. Protocol specific error code(s): “10054”, “*”, “0”. SQLSTATE=08001

Plz help me out from this
Any assistance will be appreciated!! :eek:

2

I believe you are using DB2 Universal type 2 (for UDB 8.1 and 9.1)

For NO_TRANSACTION and LOCAL_TRANSACTION:
com.ibm.db2.jcc.DB2SimpleDataSource

Also, Other Properties - driverType=2

FYI:
Oracle JDBC Thin Driver:
driverType=thin

Hope this helps, also recommend to RTM - JDBC_Adapter_User’s_Guide for more information.

  • Sathish
3

Thanx satish;
I am unable to configure my database in DB2 can u helpme.
Details in Conf. Assistance(DB2)

TCP/IP communication parameter:-
Host name…localhost
service name…tcp
Port number…5000

Database name:-
Database name…WMDB2
Database Alias …WMDB2

In node option:-
Operating system…windows
Remote instance name…DB2

System option
System name …localhost
Host name…localhost
Operating system…windows

security option bydefault

Now when i go to TEST CONNECTION am getting following err

CLI connection failed.

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

JDBC connection failed.

[IBM][CLI Driver] 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

4

I have solved DB2 config problem installing fresh DB2 now am using DB2UDB SE 8.2 this has been solved my config problem…

5

Hello friends;
I have solved this problem,to get solution plz go through this link:-

[B][url]wmusers.com