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

[Former Member]

Hi

I had resolved the issue,

In windows 2008 R2 server for DB2 , we need to install

Microsoft Visual C++ 2008 Redistributable Package (x64) and install in CI server or Application server and DB server , this is used to give the permissions to connect from App server to DB server.