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.
SAP Knowledge Base Article - Preview