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

[maria_shen]

Hello ShanmukhaRao,

As the first step, please check if you can connect to the database with below command:
1. logon as db2ecp user
2. db2 connect to ECP user sapecp using <password of sapecp user>

If it returns the same error, please check if any error in the db2diag.log.

If the database is up and running, please check whether "Microsoft Visual C++ 2008 SP1 Redistributable Package" is installed on application server. (suppose the OS type is also windows)
IBM IC79229: SQL1402C OR WINDOWS ERROR MESSAGE IS RETURNED WHEN THE MICROSOFT VISUAL C++ 2008 RUNTIM...

Kind regards
Maria

[Former Member]

Hi Maria,

Thank you for your reply,

I was able to connect the database ECP with the user sapecp and password , no issue.

Please find the output attached below.

E:\db2\db2ecp\db2_software\BIN>db2 connect to ECP user sapecp

Enter current password for sapecp:

   Database Connection Information

Database server        = DB2/NT64 9.7.6

SQL authorization ID   = SAPECP

Local database alias   = ECP

and i also checked the  "Microsoft Visual C++ 2008 SP1 , The output is attached below.

C:\Users\db2ecp>dir /b %SYSTEMROOT%\WinSxS\*VC90.CRT* | find "9.0.21022.8"

amd64_microsoft.vc90.crt_1fc8b3b9a1e18e3b_9.0.21022.8_none_750b37ff97f4f68b

x86_microsoft.vc90.crt_1fc8b3b9a1e18e3b_9.0.21022.8_none_bcb86ed6ac711f91

I think there is no issues with the above two options.

Thanks

Shanmukharao