SAP Knowledge Base Article - Preview

2987268 - DB6: SQL2071N error when connecting to database

Symptom

Database is configured to use TSM as the log archiving destination.

SQL2071N error happens when connecting to database, or starting database instance.

Error in db2diag.log during connecting database.

2020-10-11-12.28.50.414168+120 I81358747A950        LEVEL: Severe
PID     : 5636290              TID : 2213           PROC : db2sysc 0
INSTANCE: db2abc4               NODE : 000           DB   : ABC
APPHDL  : 0-8                  APPID: xxxxxxxx
AUTHID  : SAPABC               HOSTNAME: xxxxxxxx
EDUID   : 2323                 EDUNAME: db2agent (NB4) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:10151
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
 sqlcaid : SQLCA     sqlcabc: 136   sqlcode: -2071   sqlerrml: 34
 sqlerrmc: /db2/db2abc/sqllib/adsm/libtsm.a 2
 sqlerrp : SQLPGLGM
 sqlerrd : (1) 0x00000000      (2) 0x00000000      (3) 0x00000000
           (4) 0x00000000      (5) 0x00000000      (6) 0x00000000
 sqlwarn : (1)      (2)      (3)      (4)        (5)       (6)   
           (7)      (8)      (9)      (10)        (11)    
 sqlstate:     
DATA #2 : Boolean, 1 bytes
false

Error in db2diag.log during database instance start up.

2020-10-11-05.21.22.983999+120 I32649587A1670       LEVEL: Event
PID     : 38142190             TID : 1              PROC : db2start
INSTANCE: db2abc               NODE : 000
HOSTNAME: xxxxxxxx
EDUID   : 1
FUNCTION: DB2 UDB, base sys utilities, sqleStartStopSingleNode, probe:1130
DATA #1 : String, 31 bytes
/db2/db2abc/sqllib/adm/db2star2
2020-10-011-05.21.22.303801+120 E32664746A1009       LEVEL: Error (OS)
PID     : 25100384             TID : 1              PROC : db2vend
INSTANCE: db2abc               NODE : 000
HOSTNAME: xxxxxxxx
EDUID   : 1
FUNCTION: DB2 UDB, oper system services, sqloAIXLoadModuleTryShr, probe:130
CALLED  : OS, -, dlopen
OSERR   : ENOENT (2) "No such file or directory"
MESSAGE : Attempt to load specified library failed.
DATA #1 : Library name or path, 32 bytes
/db2/db2abc/sqllib/adsm/libtsm.a
DATA #2 : shared library load flags, PD_TYPE_LOAD_FLAGS, 4 bytes
2
DATA #3 : String, 423 bytes
 0509-022 Cannot load module /db2/db2abc/sqllib/adsm/libtsm.a.
 0509-150   Dependent module libApiTSM64.a(dsmapish_64.o) could not be loaded.
 0509-022 Cannot load module libApiTSM64.a(dsmapish_64.o).
 0509-026 System error: A file or directory in the path name does not exist.
 0509-022 Cannot load module /db2/db2abc/sqllib/adsm/libtsm.a.
 0509-150   Dependent module /db2/db2abc/sqllib/adsm/libtsm.a could not be loaded.
2020-10-11-05.21.22.304737+120 E32665756A883        LEVEL: Error (OS)
PID     : 25100384             TID : 1              PROC : db2vend
INSTANCE: db2abc               NODE : 000
HOSTNAME: xxxxxxxx
EDUID   : 1
FUNCTION: DB2 UDB, oper system services, sqloAIXLoadModuleTryShr, probe:140
CALLED  : OS, -, dlopen
OSERR   : ENOEXEC (8) "Exec format error"
MESSAGE : Attempt to load specified library augmented with object name failed.
DATA #1 : Library name or path, 42 bytes
/db2/db2abc/sqllib/adsm/libtsm.a(shr_64.o)
DATA #2 : shared library load flags, PD_TYPE_LOAD_FLAGS, 4 bytes
262146
DATA #3 : String, 262 bytes
 0509-022 Cannot load module /db2/db2abc/sqllib/adsm/libtsm.a(shr_64.o).
 0509-153   File /db2/db2abc/sqllib/adsm/libtsm.a is not an archive or
     the file could not be read properly.
 0509-026 System error: Cannot run a file that does not have a valid format.
 
2020-10-03-05.21.22.306312+120 I32667114A473        LEVEL: Error
PID     : 25100384             TID : 1              PROC : db2vend
INSTANCE: db2abc               NODE : 000
HOSTNAME: xxxxxxxx
EDUID   : 1
FUNCTION: DB2 UDB, database utilities, sqluFencedVendorProcessInit, probe:113
MESSAGE : SQL2071N  An error occurred while accessing the shared library
          "/db2/db2abc/sqllib/adsm/libtsm.a". Reason code: "1".
DATA #1 : ZRC, PD_TYPE_ZRC, 4 bytes
0x860F000A


Read more...

Environment

IBM Db2 for Linux, UNIX, and Windows

Keywords

SQL2071N, db2start, connect, TSM, library. , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , BC-DB-DB6-DBA , Database Administration , Problem

About this page

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

Search for additional results

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