configuration Issue

[Former Member]

Hi All,

We trying to connect from our SAP System with Oracle and Solaris to DB2 Connect..

we already Maintained DB2 Details in DBCO Transactions and its throws error in ST22 as below.

Connect to DB2CONN as db2inst1 with DB6_DB_NAME=axsser01; DB6_DB_SVCENAME=db2c_db2inst1;

DB6_DB_HOST=resp1.timesresponse.com; [dbcon.c#3729]

DB6 (DB2 UDB) UNICODE database interface 700.08 [opt] [dbdb6.c#11689]

..retrieving configuration parameters [dbdb6.c#11745]

..done [dbdb6.c#12366]

unable to load DB2 library 'libdb2.so'. Reason: ld.so.1: disp+work: fatal: libdb2.so: open

failed: No such file or directory [dbdb6.c#10992]

• ERROR in getConfigurationAndEnvironmentHandle[dbdb6.c, 12437] CON = -1 (BEGIN)

[dbsldb6trc.c#1475]

&+ DbSlConnectDB6: Unable to load DB2 libraries. Connect failed.

[dbsldb6trc.c#1475]

&+

[dbsldb6trc.c#1475]

&+

[dbsldb6trc.c#1475]

&+ ABAP location info 'Y_TESTCON', 64

[dbsldb6trc.c#1475]

&+ SAP user 'INDIGOS', transaction code 'SE38'

[dbsldb6trc.c#1475]

&+

[dbsldb6trc.c#1475]

• ERROR in getConfigurationAndEnvironmentHandle[dbdb6.c, 12437] (END) [dbsldb6trc.c#1475

dbtran ERROR LOG (hdl_dbsl_error): DbSl 'PRE' [dbtran.c#7652]

RSLT: {dbsl=29, tran=16384} [dbtran.c#7652]

FHDR: {tab='ZRAMCO', fcode=53, mode=2, bpb=0, dbcnt=0, crsr=1, [dbtran.c#7652]

hold=0, keep=0, xfer=0, pkg=0, upto=1, init:b=0, [dbtran.c#7652]

init:p=(nil), init:#=26, wa:p=0xfffffffe7e8bfc74, wa:#=26} [dbtran.c#7652]

Regards,

Panu

[ImtiazKaredia]

I think you also need DB2 runtime client installed on server other than maintaining DBCO.

[Former Member]

I have searched it, is the correct note for implementation 200164?

Suggest on this pls.

Regards

Panu

Edited by: kumar panu on Mar 18, 2011 9:39 AM

[ImtiazKaredia]

Yes this note seems correct

[Former Member]

i am unable to connect to DB2 Server....

Test Connection

Error: The database returned a value containing an error

Please find the logs as below.

sm21:

Database error -1337 at PRE access to table ZPRAMOD

> SQL1337N The service "db2c_db2inst1" was not found

wp:

Supported features:

..retrieving configuration parameters

..done

DB2 library successfully loaded DB2 library '/usr/sap/TOI/SYS/global/db6/SUNOS_64/db6_clidriver/lib/libdb2.so' successfully loade

Running with UTF-8 Unicode

Running with CLI driver.

• ERROR in DB6Connect[dbdb6.c, 1786] CON = 1 (BEGIN)

&+ DbSlConnectDB6( SQLDriverConnect 😞 [IBM][CLI Driver] SQL1337N The service "db2c_db2inst1" was not found

&+

&+

&+ ABAP location info 'Y_TESTCON', 66

&+ SAP user 'XXXX', transaction code 'SE38'

&+

• ERROR in DB6Connect[dbdb6.c, 1786] (END)

• ERROR => DbSlConnect to 'axsser01' as 'db2inst1' failed

bdb6.c 1791]

***LOG BY4=> sql error -1337 performing PRE on table ZPRAMOD [dbtran#5 @ 7598] [dbtran 7598 ]

***LOG BY0=> SQL1337N The service "db2c_db2inst1" was not found [dbtran#5 @ 7598] [dbtran 7598 ]

dbtran ERROR LOG (hdl_dbsl_error): DbSl 'PRE'

RSLT: {dbsl=99, tran=1}

FHDR: {tab='ZPRAMOD', fcode=53, mode=2, bpb=0, dbcnt=0, crsr=1,

hold=0, keep=0, xfer=0, pkg=0, upto=1, init:b=0,

init:p=(nil), init:#=26, wa:p=0xfffffffe7d0bffbc, wa:#=26}

ri Mar 18 19:53:43 2011

Deactivate ASTAT hyper index locking