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 for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.