DB2 - Problem description
Problem IT40408 | Status: Closed |
DB2 V11.5.4 DB2START GETS UNDEFINED SYMBOL CRYPTO_NUM_LOCKS ERROR | |
product: | |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 | |
Problem description: | |
When you execute v11.5.4 db2start, you may find this message in db2diag.log: ----- 2022-03-11-19.41.36.506347+540 I10686E1317 LEVEL: Error PID : 6183 TID : 140689736197888 PROC : db2sysc INSTANCE: XXXXXXX NODE : 000 HOSTNAME: XXXXXXXX EDUID : 1 EDUNAME: db2sysc FUNCTION: DB2 Common, OSSe, OSSHLibrary::getFuncAddress, probe:60 DATA #1 : String, 63 bytes /usr/lib64/libcrypto.so.1.1: undefined symbol: CRYPTO_num_locks CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol) [0] 0x00007FF4FCC5AD52 /home/XXXXXXXX/sqllib/lib64/libdb2osse.so.1 + 0x249D52 [1] 0x00007FF4FCC5BB27 ossLog + 0x77 [2] 0x00007FF4FCC68CCF _ZN11OSSHLibrary14getFuncAddressEPK25OSSLibGetFuncAddressParamP2 4OSSLibGetFuncAddressInfo + 0x38F [3] 0x00007FF5068F9DA1 _ZN16SqloCryptoHandle21SqloCryptoHandle_InitEPKc + 0x271 [4] 0x00007FF5068FA178 sqloRemStgMThreadOpenSSLOneTimeInit + 0x88 [5] 0x00007FF5068C8688 sqloRemStgOneTimeInit + 0x798 [6] 0x000000000041C830 _Z11sqleSysCtlrv + 0x500 [7] 0x00007FF5069689D8 /home/XXXXXXXX/sqllib/lib64/libdb2e.so.1 + 0x99869D8 [8] 0x00007FF50696A0EA sqloRunInstance + 0xA3A [9] 0x000000000041939E DB2main + 0xD6E [10] 0x00007FF5069741C2 sqloEDUEntry + 0xD2 [11] 0x00007FF50CE3F2DE /usr/lib64/libpthread.so.0 + 0x82DE [12] 0x00007FF4FBDA2E83 clone + 0x43 ----- | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Db2 Version 11.5 * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 Version 11.5.7.0 * **************************************************************** | |
Local Fix: | |
If the system has OpenSSL 1.0 (or higher) installed, you can set DB2_OBJECT_STORAGE_SETTINGS=NoThreadLocking to avoid the error. Example: db2set DB2_OBJECT_STORAGE_SETTINGS=NoThreadLocking If the system has OpenSSL 0.x installed, you can set DB2_OBJECT_STORAGE_SETTINGS=CRYPTOLibrary= to point to the location of your OpenSSL library. Example: db2set DB2_OBJECT_STORAGE_SETTINGS=CRYPTOLibrary=/usr/lib64/libcrypto.s o.6 | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * Db2 Version 11.5 * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 Version 11.5.7.0 * **************************************************************** | |
Comment | |
Problem was first fixed in Db2 Version 11.5.7.0 | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 27.03.2022 05.04.2022 05.04.2022 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |