Db2 database connection Failed error code 000256

[Former Member]

Hi

We are installing Distributed System SAP ECC 6.0 EHP 6 on windows 2008 R2 EE with Database DB2 version 9.7.

We had installed SAP Global Host preparation on Host 1 and Db2 database on Host 2 successfully.We are installing SAP as a local Installation not a Domain Installation. As we  know SAP recommends for a Domain Installation for Distributed installation , but here in client we are not having the Domain servers.So we are installing as a Local installation.We followed the SAP installation guides.

(in Distributed installation method , we are installing SAP Global Host Preparation and Central instance on one Host and Database on Another Host)

While We are installing Central Instance(CI) on Host 1 we are getting an Error while starting ABAP System in the CI installation process and CI installation Stopped in middle at step 7.

SAP System was starting and Stopping immediately i.e disp+work.Exe Dispatcher was going to Stopped condition.

Here Database was up and running fine.

Please find the error Log in DEV_W0 attached below.

Running with CLI driver.

C  *** ERROR in DB6Connect[dbdb6.c, 1797] CON = 0 (BEGIN)

C  &+     DbSlConnectDB6( SQLConnect 😞 [IBM][CLI Driver] SQL1042C  An unexpected system error occurred.  SQLSTATE=58004   

C  &+                                                                                                                      

C  &+                                                                                                                      

C  *** ERROR in DB6Connect[dbdb6.c, 1797] (END)

C  *** ERROR => DbSlConnect to 'ECP' as 'sapecp' failed

[dbdb6.c      1802]

M  ***LOG R19=> ThInit, db_connect ( DB-Connect 000256) [thxxhead.c   1487]

M  in_ThErrHandle: 1

M  *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c   11295]

The Error log in Syslog  was attached below.

SAP Basis System: Initialization           DB-Connect Failed, Return Code  000256

Message server and gateway services are up and running but only Dispatcher going down.

Thanks

ShanmukhaRao

[Manas_Vincit]

Hi,

Can you please attach complete R3trans.log and R3trans -d  output?

Thanks

Manas

[Former Member]

Hi manas

Please find the R3trans -d output  attached below.

D:\usr\sap\ECP\SYS\exe\uc\NTAMD64>r3trans -d

This is r3trans version 6.22 (release 720 - 03.06.11 - 17:57:00).

unicode enabled version

R3trans=>sapparam(1c): No Profile used.

R3trans=>sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

2EETW169 no connect possible: "connect failed with DBLI_RC_LOAD_LIB_FAILED."

r3trans finished (0012).

Thanks

ShanmukhaRao

[former_member213250]

Hi Shanmukha Rao

From R3trans error

2EETW169 no connect possible: "connect failed with DBLI_RC_LOAD_LIB_FAILED."

r3trans finished (0012).

Either one of the following environment variables is not setup correctly

==> DBMS_TYPE
==> DIR_LIBRARY

Please ensure that the DIR_LIBRARY is pointing to the shared libraries since you are getting the error connect failed with DBLI_RC_LOAD_LIB_FAILED

eg : C:\usr\sap\<SID>\SYS\exe\uc\NTADM64

Hope it helps.

Regards
Venkat

[Former Member]

Hi Venkat,

It is not working , i have given environment variables as DBMS_TYPE = db6

and  DIR_LIBRARY = \\BASISTEST1\sapmnt\ECP\SYS\exe\uc\NTAMD64

in both application server and Database server also and restarted the server , but it is not working.

Thanks

ShanmukhaRao