DB2 Connection enabling Error

, ,
1

Hi All,

i am working on 7.1.1 version having 6.5 JDBC Adapter and DB2 Databse is 9.5 version on sunsolaris operating system.

while am enable the connection i got the following error.

Error encountered
[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource DWAFCommon.DB2Connection:DB2Connection.
[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.DB2DataSource”.
DB2 SQL Error: SQLCODE=-1001, SQLSTATE=2E000, SQLERRMC=SAPDB2FIQ , DRIVER=3.53.70

DWAFCommon.DB2Connection:DB2Connection Details

Connection Type JDBC Adapter Connection
Package Name DWAFCommon
Connection Properties
Transaction Type NO_TRANSACTION
DataSource Class com.ibm.db2.jcc.DB2DataSource
serverName 10.132.37.162
user db2fiq
password ******
databaseName sapdb2fiq
portNumber 5900
networkProtocol tcp/ip
Other Properties driverType=4
Connection Management Properties
Enable Connection Pooling true
Minimum Pool Size 1
Maximum Pool Size 10
Pool Increment Size 1
Block Timeout (msec) 1000
Expire Timeout (msec) 1000
Startup Retry Count 0
Startup Backoff Timeout (sec) 10

and also tried with another datasource class ,i got same error

WAFCommon.DB2Connection:DB2Connection Details
Connection Type JDBC Adapter Connection
Package Name DWAFCommon
Connection Properties
Transaction Type NO_TRANSACTION
DataSource Class com.ibm.db2.jcc.DB2SimpleDataSource
serverName 10.132.37.162
user db2fiq
password ******
databaseName sapdb2fiq
portNumber 5900
networkProtocol tcp/ip
Other Properties driverType=4
Connection Management Properties
Enable Connection Pooling true
Minimum Pool Size 1
Maximum Pool Size 10
Pool Increment Size 1
Block Timeout (msec) 1000
Expire Timeout (msec) 1000
Startup Retry Count 0
Startup Backoff Timeout (sec) 10

please help me where is the problem. and suggest the correct settings

regards,
anil kumar e

2

Probably one of ur connection parameters, please check them again.

Not sure of this -->‘Other Properties driverType=4’ usually its ‘Thin’, but thats for Oracle…

Also, check if you have the classes12.zip loaded properly…

S.

3

try changing the datasource class to “com.wm.dd.jdbc.db2.DB2Driver”

4

Hi,

i tried with the com.wm.dd.jdbc.db2.DB2Driver got the below error.

[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource DWAFCommon.DB2ConnectionB2Connection.
[ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.
[ADA.1.204] unable to find com.wm.dd.jdbc.db2.DB2Driver

5

DB2 database version is 9.5 SP1 and jar file am using is

IntegrationServer\lib\jars\db2java.zip
IntegrationServer\lib\jars\db2jcc.jar
IntegrationServer\lib\jars\db2jcc4.jar
IntegrationServer\lib\jars\db2jcc_license_cu.jar
IntegrationServer\lib\jars\db2policy.jar
IntegrationServer\lib\jars\db2qgjava.jar
IntegrationServer\lib\jars\db2umplugin.jar

i kept these files in IntegrationServer\lib\jars location am getting below error.

Error encountered
[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource DWAFCommon.DB2Connection:DB2Connection.
[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”.
[jcc][t4][2030][11211][3.53.70] A communication error occurred during operations on the connection’s underlying socket, socket input stream,
or socket output stream. Error location: Reply.fill(). Message: Insufficient data. ERRORCODE=-4499, SQLSTATE=08001

connection details are

Connection Type JDBC Adapter Connection
Package Name DWAFCommon
Connection Properties
Transaction Type NO_TRANSACTION
DataSource Class com.ibm.db2.jcc.DB2SimpleDataSource
serverName 10.132.37.162
user db2fiq
password ******
databaseName sapdb2fiq
portNumber 5900
networkProtocol tcp/ip
Other Properties driverType=4
Connection Management Properties
Enable Connection Pooling true
Minimum Pool Size 1
Maximum Pool Size 10
Pool Increment Size 1
Block Timeout (msec) 1000
Expire Timeout (msec) 1000
Startup Retry Count 0
Startup Backoff Timeout (sec) 10

can any one help wat this error,why am getting insuffient data error and am i using correct jar files to connect to DB2 databse for version 9.5 sp1.

6

yes i can able connect to DB2 now with following settings thanx for reply.

WAFCommon.DB2ConnectionB2Connection Details
Connection Type JDBC Adapter Connection
Package Name DWAFCommon
Connection Properties
Transaction Type NO_TRANSACTION
DataSource Class com.ibm.db2.jcc.DB2SimpleDataSource
serverName 10.132.37.162
user db2fiq
password ******
databaseName fiq
portNumber 5900
networkProtocol tcp/ip
Other Properties driverType=4
Connection Management Properties
Enable Connection Pooling true
Minimum Pool Size 1
Maximum Pool Size 10
Pool Increment Size 1
Block Timeout (msec) 1000
Expire Timeout (msec) 1000
Startup Retry Count 0
Startup Backoff Timeout (sec) 10

i used the these jar file

IntegrationServer\lib\jars\db2java.zip
IntegrationServer\lib\jars\db2jcc.jar
IntegrationServer\lib\jars\db2jcc4.jar
IntegrationServer\lib\jars\db2jcc_license_cu.jar

regards,
anil kumar

7

Hi Anil Kumar,

I cannot really see what you have done or changed so that you got rid of this “Insufficient Data” issue - would you be so kind and tell us what has been the solution to this?!

Thanks in advance
Detlev