DISP+WORK Stop DB2 with Windows 2008R2 ERROR => unable to load DB2 library

[Former Member]

I'm having problem to the start of SAP PI (DB2 Win2008R2)

How do I run X-R3trans not get error .. see below

C:\Users\gqaadm>R3trans -x

This is R3trans version 6.14 (release 701 - 03.06.11 - 17:57:00).

unicode enabled version

R3trans finished (0000).

But when checking the log dev_w0 found the errors below,

I've done various checks, environment variables, and updated the kernel, disp+work to the latest version,but nothing worked.

C Supported features:

C

C ..retrieving configuration parameters

C ..done

C *** ERROR => unable to load DB2 library 'E:\usr\sap\GQA\DVEBMGS15\exe/db6_clidriver\bin\db2app64.dll'. Reason: A dynamic link library (DLL) initialization routine failed.

[dbdb6.c 11190]

C *** ERROR in getConfigurationAndEnvironmentHandle[dbdb6.c, 12682] CON = -1 (BEGIN)

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

C &+

C &+

C *** ERROR in getConfigurationAndEnvironmentHandle[dbdb6.c, 12682] (END)

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

M in_ThErrHandle: 1

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

Does anyone have any idea what could be?

Thank you!

[former_member189725]

Can you please paste the trans.log which got successfully completed. I would like to see from which location the library was read and loaded in this case.

Also try manually copying the folder db6_clidriver from
<host>\sapmnt\<SAPSID>\SYS\global\db6\<platform> to E:\usr\sap\GQA\DVEBMGS15\exe.

[Former Member]

I had already done so, copy the db6_clidriver to E:\usr\sap\GQA\DVEBMGS15\exe, but it did not work, the directory permissions are correct. The following log trans.log

4 ETW000 R3trans version 6.14 (release 701 - 03.06.11 - 17:57:00).

4 ETW000 unicode enabled version

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time : 05.01.2012 - 09:11:13

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -d

4 ETW000 trace at level 2 opened for a given file pointer

4 ETW000 [ dev trc,00000] Thu Jan 05 09:11:16 2012 25397 0.025397

4 ETW000 [ dev trc,00000] db_con_init called 16 0.025413

4 ETW000 [ dev trc,00000] create_con (con_name=R/3) 617 0.026030

4 ETW000 [ dev trc,00000] Loading DB library 'dbdb6slib.dll' ... 741 0.026771

4 ETW000 [ dev trc,00000] DlLoadLib success: LoadLibrary("dbdb6slib.dll"), hdl 0, addr 0000000186980000

4 ETW000 1366 0.028137

4 ETW000 [ dev trc,00000] using "E:\usr\sap\GQA\SYS\exe\uc\NTAMD64\dbdb6slib.dll" 10 0.028147

4 ETW000 [ dev trc,00000] Library 'dbdb6slib.dll' loaded 13 0.028160

4 ETW000 [ dev trc,00000] function DbSlExpFuns loaded from library dbdb6slib.dll 12 0.028172

4 ETW000 [ dev trc,00000] Version of 'dbdb6slib.dll' is "700.08", patchlevel (0.143) 980 0.029152

4 ETW000 [ dev trc,00000] function dsql_db_init loaded from library dbdb6slib.dll 18 0.029170

4 ETW000 [ dev trc,00000] function dbdd_exp_funs loaded from library dbdb6slib.dll 16 0.029186

4 ETW000 [ dev trc,00000] New connection 0 created 24 0.029210

4 ETW000 [ dev trc,00000] 000: name = R/3, con_id = -000000001, state = DISCONNECTED, tx = NO , hc = NO , perm = YES,

4 ETW000 reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 33 0.029243

4 ETW000 [ dev trc,00000] db_con_connect (con_name=R/3) 16 0.029259

4 ETW000 [ dev trc,00000] find_con_by_name found the following connection for reuse: 10 0.029269

4 ETW000 [ dev trc,00000] 000: name = R/3, con_id = 000000000, state = DISCONNECTED, tx = NO , hc = NO , perm = YES,

4 ETW000 reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 26 0.029295

4 ETW000 [ dev trc,00000] DB6 (DB2 UDB) UNICODE database interface 700.08 [opt] 2566 0.031861

4 ETW000 [ dev trc,00000] DB6 shared library (dbdb6slib) patchlevels 22 0.031883

4 ETW000 [ dev trc,00000] (0.2) DB6: patch collection 06/08 (note 1172220) 12 0.031895

4 ETW000 [ dev trc,00000] (0.9) DB6: reduce calls to REG_LIST_VARIABLES (note 1232030) 11 0.031906

4 ETW000 [ dev trc,00000] (0.9) IA64 alignment errors (note 1245982) 11 0.031917

4 ETW000 [ dev trc,00000] (0.10) DB6: UR cursor with CC_RELEASE attribute (note 1244963) 11 0.031928

4 ETW000 [ dev trc,00000] (0.10) DB6: DB6_DBSL_RUNSTATS_V8 with sampling rate (note 1245458)

4 ETW000 15 0.031943

4 ETW000 [ dev trc,00000] (0.11) DB6: trace warnings on setting SQL_ATTR_CHAINING_BEGIN (note 1247697)

4 ETW000 15 0.031958

4 ETW000 [ dev trc,00000] (0.19) DB6: patch collection 11/08 (note 1263885) 11 0.031969

4 ETW000 [ dev trc,00000] (0.19) DB6: patch collection 11/08 (note 1264825) 45 0.032014

4 ETW000 [ dev trc,00000] (0.21) DB6: SUBSITUTE_VALUES causes wrong estimated statement si (note 1277235)

4 ETW000 26 0.032040

4 ETW000 [ dev trc,00000] (0.33) DB6: patch collection 02/09 (note 1294443) 10 0.032050

4 ETW000 [ dev trc,00000] (0.36) DB6: cobra enhancements (note 1315762) 11 0.032061

4 ETW000 [ dev trc,00000] (0.40) DB6: configurable cc_release attribute for UR cursors (note 1324532)

4 ETW000 15 0.032076

4 ETW000 [ dev trc,00000] (0.41) DB6: unexpected token INLINE LENGTH (note 1334179) 11 0.032087

4 ETW000 [ dev trc,00000] (0.42) DB6: cobra enhancements part 2 (note 1315762) 10 0.032097

4 ETW000 [ dev trc,00000] (0.48) DB6: substitution of aliases in optguidelines (note 1352458)

4 ETW000 15 0.032112

4 ETW000 [ dev trc,00000] (0.53) DB6: login timeout for secondary connections (note 1364372)

4 ETW000 14 0.032126

4 ETW000 [ dev trc,00000] (0.57) DB6: revalidate views in status active=N (note 1376439) 11 0.032137

4 ETW000 [ dev trc,00000] (0.57) DB6: create index with 9.7 and virtual tables (note 1371882)

4 ETW000 14 0.032151

4 ETW000 [ dev trc,00000] (0.58) DB6: optimized performance for R3load with DEF_CRT (note 1378018)

4 ETW000 14 0.032165

4 ETW000 [ dev trc,00000] (0.62) DB6: timeout for CREATE/DROP TRIGGER (note 1387865) 11 0.032176

4 ETW000 [ dev trc,00000] (0.66) DB6: patch collection 10/09 (note 1397804) 11 0.032187

4 ETW000 [ dev trc,00000] (0.69) DB6: Potentially unnoticed rollback during array operation (note 1406740)

4 ETW000 15 0.032202

4 ETW000 [ dev trc,00000] (0.74) DB6: client affinity support (note 1414616) 10 0.032212

4 ETW000 [ dev trc,00000] (0.77) DB6: CLI TraceRefreshInterval during parallel import (note 1426985)

4 ETW000 15 0.032227

4 ETW000 [ dev trc,00000] (0.84) DB6: patch collection 03/10 (note 1447436) 10 0.032237

4 ETW000 [ dev trc,00000] (0.92) Improved overflow error handling (note 1463647) 11 0.032248

4 ETW000 [ dev trc,00000] (0.94) DB6: patch collection 05/10 (note 1364372) 10 0.032258

4 ETW000 [ dev trc,00000] (0.94) DB6: patch collection 05/10 (note 1470824) 11 0.032269

4 ETW000 [ dev trc,00000] (0.96) DB6: return original schema in shadow system (note 1474361)

4 ETW000 14 0.032283

4 ETW000 [ dev trc,00000] (0.99) ABAP: Return technical database PPMS information (note 1419552)

4 ETW000 14 0.032297

4 ETW000 [ dev trc,00000] (0.99) DB6: literals for decimal columns of value 0 (note 1482790)

4 ETW000 14 0.032311

4 ETW000 [ dev trc,00000] (0.101) MSSQL: database fingerprint (note 1405158) 12 0.032323

4 ETW000 [ dev trc,00000] (0.102) DB6: tolerate client deletes on virtual tables (note 1484286)

4 ETW000 15 0.032338

4 ETW000 [ dev trc,00000] (0.111) DB6: SQLE_CLIENT_INFO_USERID including quotes (note 1508803)

4 ETW000 15 0.032353

4 ETW000 [ dev trc,00000] (0.112) DB6: revalidation of view failed (note 1376439) 10 0.032363

4 ETW000 [ dev trc,00000] (0.113) DB6: DROP INDEX on virtual table ignored (note 1514380) 12 0.032375

4 ETW000 [ dev trc,00000] (0.116) DB6: FOR ALL ENTRIES statement with SUBSTITUTE LITERALS (note 1520152)

4 ETW000 14 0.032389

4 ETW000 [ dev trc,00000] (0.135) DB6: patch collection 03/11 (note 1568512) 11 0.032400

4 ETW000 [ dev trc,00000] (0.138) DB6: REORG table causes SQL0108 (note 1575617) 16 0.032416

4 ETW000 [ dev trc,00000] (0.139) DB2 z/OS: SET CURRENT DEGREE = 'ANY' Hint (note 1579352) 12 0.032428

4 ETW000 [ dev trc,00000] (0.143) DB6: FOR ALL ENTRIES with SUBSTITUTE VALUES (note 1587338)

4 ETW000 15 0.032443

4 ETW000 [ dev trc,00000] Supported features: 8 0.032451

4 ETW000 [ dev trc,00000] ..retrieving configuration parameters 13 0.032464

4 ETW000 [ dev trc,00000] ..done 303 0.032767

4 ETW000 [ dev trc,00000] DB2 library successfully loaded DB2 library '
LDEVPI\sapmnt\GQA\SYS\global\db6\WINDOWS_AMD64\db6_clidriver\bin\db2app64.dll' successfully loaded

4 ETW000 [ dev trc,00000] Running with UTF-8 Unicode 12 0.598464

4 ETW000 [ dev trc,00000] Thu Jan 05 09:11:17 2012 221512 0.819976

4 ETW000 [ dev trc,00000] Running with CLI driver. 18 0.819994

4 ETW000 [ dev trc,00000] DB2 client driver version '09.05.0006' 337658 1.157652

4 ETW000 [ dev trc,00000] Connected to DB server type 'DB2/NT64' 1044 1.158696

4 ETW000 [ dev trc,00000] Connected to DB server version '09.05.0006' 213 1.158909

4 ETW000 [ dev trc,00000] Connected to 'GQA' as 'SAPGQA' schema 'SAPGQA' o.k. 26010 1.184919

4 ETW000 [ dev trc,00000] Connected: con_hdl=0 ; appl_hdl=664; appl_id="fe80::a462:51b7:5af4:ca11%13.26308.120105111117"

[former_member189725]

R3trans is loading the library from
LDEVPI\sapmnt\GQA\SYS\global\db6\WINDOWS_AMD64\db6_clidriver\bin\db2app64.dll

workprocess is loading the library from E:\usr\sap\GQA\DVEBMGS15\exe/db6_clidriver\bin\db2app64.dll

So please manually copy the db6_clidriver forder under
LDEVPI\sapmnt\GQA\SYS\global\db6\WINDOWS_AMD64\ to the directory E:\usr\sap\GQA\DVEBMGS15\exe

and then start the system . The sapcpe generally copies it during the startup of the instance which is mentioned in the start profile of the instance .

Good Luck.

[Former Member]

So, I did manually copy the directory \ \ LDEVPI \ sapmnt \ GQA \ SYS \ global \ DB6 \ WINDOWS_AMD64 \ to the directory E: \ usr \ sap \ GQA \ DVEBMGS15 \ exe again and it did not work.

any ideas?

thank you

[Former Member]

Hello Junior,

In which exe path, you have extracted kernel files during kernel upgrade? Please clarify. Have you run saproot.sh script after kernel upgrade?

Thanks,

Siva Kumar

[Former Member]

Hello Siva,

The SAP is installed on Windows 2008 R2, so I updated the kernel to the latest version to see if the problem was solved, because with the previous kernel was no longer working.

The files were extracted and copied manually to the directories;

E:\usr\sap\GQA\DVEBMGS15\exe

E:\usr\sap\GQA\SYS\exe\uc\NTAMD64

E:\usr\sap\GQA\SCS16\exe

Thanks,

Junior

[Former Member]

Hello Junior,

Have you extracted both SAPEXE and SAPEXEDB into those paths?

Have you run saproot.sh/oraroot.sh script after kernel upgrade?

Thanks,

Siva Kumar

[Former Member]

Hello Siva,

SAP is installed on Windows 2008R2, and Windows does not have scripts.

The kernel has been installed correctly. But the problem persists.

anyone have more suggestions?

Thanks

Junior

Edited by: Junior on Jan 6, 2012 1:10 AM

[former_member189725]

Can you just copy the file db2app64.dll from
LDEVPI\sapmnt\GQA\SYS\global\db6\WINDOWS_AMD64\db6_clidriver\bin\ to E:\usr\sap\GQA\DVEBMGS15\exe/db6_clidriver\bin\ .

Also check the permission of the file db2app64.dll.

[Former Member]

The problem was solved!

I had to review all the permissions of the directories below was wrong to permissions ..

E:\

E:\usr

E:\usr\sap

E:\usr\sap\GQA

E:\usr\sap\GQA\DVEBMGS15

E:\usr\sap\GQA\DVEBMGS15\exe

E:\usr\sap\GQA\DVEBMGS15\exe/db6_clidriver

E:\usr\sap\GQA\DVEBMGS15\exe/db6_clidriver\bin

E:\usr\sap\GQA\DVEBMGS15\exe/db6_clidriver\bin\db2app64.dll

Thank you all for your help.

Junior

[Former Member]

Hello,

Did you do kernel upgrade on this system?

If yes, DB specific binaries were not copied properly. If not, check if any kernel soft links are missing. You can compare with other systems in your landscape.

Thanks,

Siva Kumar

[Former Member]

Yes I did upgrade the kernel, comparisons with the other system and all files are in folders ...

My first attempt was to copy the kernel from my other SAP PI for that, but also failed.

Any idea?

[Former Member]

Hi,

Can you check the permission of the files?

Also, In Windows,Copy kernel files from other system copy to the original directory of target system kernel instead of newly created.

Before you copy the files, make sure you stop all the SAP, DB services and MMC also.

Thanks,

Sravanthi