SAP Knowledge Base Article - Preview

2786441 - R3trans connect fails with SQL error 'SQL5005C'

Symptom

SAP system startup fails.  You observe 'R3trans' (in trans.log) is failing with sqlcode SQL5005C.

----------------------------------------------------------------------------------------------------------------------------------------
4 ETW000 [ dev trc,00000] DB2Trc: dbs/db2/dsn_alias is set (XXX) -> we use the DB2 Connect fail over feature
4 ETW000 [ dev trc,00000] Set _cliFeatures.sqlGetDiagFieldBytes = TRUE
4 ETW000 [ dev trc,00000] DB2Trc: 000000 CLI_ALLOC_ENV 1
4 ETW000 [ dev trc,00000] Could not open db2applcompat.ini file '/sapmnt/XXX/global/db2applcompat.ini'.
4 ETW000 [ dev trc,00000] DB2Trc: Application Compatibility ignored.
4 ETW000 [ dev trc,00000] Using user(xxxadbc) and password(<pwd>) from password service.
4 ETW000 [ dev trc,00000] DB2Trc: trace level of dbdb2cli set to 1
4 ETW000 [ dev trc,00000] COLLECTION ID used is "SAP1101U"
4 ETW000 [dbdb2cli.c ,00000] *** ERROR => DB2 Call 'SQLConnectW' Error: conHdl = 00 SQLCODE = -5005 : [IBM][CLI Driver] SQL5005C The operation failed because the da
tabase manager failed to access either the database manager configuration file or the database configuration file.
4 ETW000 [dbdb2s.c ,00000] *** ERROR => CONNECT failed with SQL error '-5005'
4 ETW000 [ dblink ,00000] ***LOG BY2=>sql error -5005 performing CON
4 ETW000 [ dblink ,00000] ***LOG BY0=>[IBM][CLI Driver] SQL5005C The operation failed because the database manager failed to access either the database manager c
onfiguration file or the database configuration file.
4 ETW000 [dbdb2cli.c ,00000] *** ERROR => DB2 Call 'SQLGetInfoW' Error: conHdl = 00 SQLCODE = -99999 : invalid connection handle 0
2EETW169 no connect possible: "DBMS = DB2/MVS --- "
----------------------------------------------------------------------------------------------------------------------------------------

Further analysis using truss (or linux strace) shows that R3trans execution is failing due to an unavailable resource.  Problem is pointing to the 'db2dsdriver.cfg' file.

----------------------------------------------------------------------------------------------------------------------------------------
open("/usr/sap/XXX/D50/exe/db2_clidriver/conv/ucs20819.cnv", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/usr/sap/XXX/D50/exe/db2_clidriver/conv/IBM00819.ucs", O_RDONLY) = -1 ENOENT (No such file or directory)
access("/sapmnt/XXX/global/db2dsdriver.cfg", F_OK) = 0
open("/sapmnt/XXX/global/db2dsdriver.cfg", O_RDONLY) = 4
fcntl(4, F_SETLK, {type=F_RDLCK, whence=SEEK_SET, start=0, len=0}) = -1 EAGAIN (Resource temporarily unavailable)
fcntl(4, F_GETLK, {type=F_UNLCK, whence=SEEK_SET, start=0, len=0, pid=0}) = 0
close(4) = 0
open("/usr/sap/XXX/D50/exe/db2_clidriver/msg/en_US.iso88591/db2sql.mo", O_RDONLY) = 4
fstat(4, {st_mode=S_IFREG|0777, st_size=443901, ...}) = 0
mmap(NULL, 446464, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f4d6a1ae000
read(4, "\0\0", 2) = 2
read(4, "\330\261\0\0", 4) = 4
read(4, "\0\0\0\0\0\0\0\0T\0\0\0\1\0\0\0/\0\0\0T\0\0\0\2\0\0\0r\0\0\0"..., 443895) = 443895
close(4) = 0
write(3, "4 ETW000 [dbdb2cli.c ,00000] "..., 283) = 283
write(3, "4 ETW000 [dbdb2s.c ,00000] "..., 83) = 83
write(3, "4 ETW000 [ dblink ,00000] "..., 76) = 76
write(3, "4 ETW000 [ dblink ,00000] "..., 222) = 222
write(3, "4 ETW000 [dbdb2cli.c ,00000] "..., 134) = 134
write(3, "2EETW169 no connect possible: \"D"..., 52) = 52
write(1, "2EETW169 no connect possible: \"D"..., 522EETW169 no connect possible: "DBMS = DB2/MVS --- "
) = 52
write(1, "R3trans finished (0012).\n", 25R3trans finished (0012).
----------------------------------------------------------------------------------------------------------------------------------------


Read more...

Environment

  • IBM DB2 z/OS
  • Network File System v3
  • Netweaver AS

Product

SAP NetWeaver all versions

Keywords

-5005 SQL5005C mainframe db2cli.ini connect.ini DB2Connect , KBA , BC-DB-DB2 , DB2 for z/OS , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.