Question Re: Db2 database connection Failed error code 000256 in Technology Q&A

Db2 database connection Failed error code 000256

Former Member — Tue, 04 Nov 2014 11:01:00 GMT

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 *** 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

Re: Db2 database connection Failed error code 000256

maria_shen — Wed, 05 Nov 2014 05:45:37 GMT

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 RUNTIME LIBRARIES ARE NOT …

Kind regards
Maria

Re: Db2 database connection Failed error code 000256

Former Member — Wed, 05 Nov 2014 06:02:55 GMT

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

Re: Db2 database connection Failed error code 000256

Manas_Vincit — Wed, 05 Nov 2014 10:04:49 GMT

Hi,

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

Thanks

Manas

Re: Db2 database connection Failed error code 000256

Former Member — Mon, 10 Nov 2014 08:15:53 GMT

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

Re: Db2 database connection Failed error code 000256

former_member213250 — Mon, 10 Nov 2014 08:46:19 GMT

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

Re: Db2 database connection Failed error code 000256

Former Member — Mon, 10 Nov 2014 10:13:59 GMT

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

Re: Db2 database connection Failed error code 000256

Former Member — Thu, 13 Nov 2014 08:54:58 GMT

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.