DB2 - Problem description
Problem IT30730 | Status: Closed |
LINUXIA32 AND LINUXAMD64 HAVE DIFFERENT VALUES OF SQLE_LEVEL_BUILD_ID6 ON V11.1 FP4 IFIX001 | |
product: | |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 | |
Problem description: | |
linuxia32 and linuxamd64 have different values of SQLE_LEVEL_BUILD_ID6 on V11.1 FP4 IFIX001. Those should be the same value. If those are different, it might cause that 32bit embedded SQL application locally executed by non-db2 instance user gets -5005 error when connecting to a database, if the user do not have a write permission on the db2systm file. The following logs might be written in the db2diag.log when hitting this APAR. (test132 is a 32bit embedded SQL application) 2019-09-17-10.06.12.520116+540 I149127G477      LEVEL: Severe PID   : 26195         TID : 4096248384   PROC : test132 INSTANCE: XXXXXXXX       NODE : 000 HOSTNAME: XXXXXXXX FUNCTION: DB2 UDB, config/install, sqlfcsys, probe:1 RETCODE : ZRC=0xFFFFEC73=-5005      SQL5005C  The operation failed because the database manager failed to      access either the database manager configuration file or the database      configuration file. 2019-09-17-10.06.29.313282+540 E149974G984      LEVEL: Error (OS) PID   : 26268         TID : 4096248384   PROC : test132 INSTANCE: XXXXXXXX       NODE : 000 HOSTNAME: XXXXXXXX FUNCTION: DB2 UDB, oper system services, sqloopenp, probe:80 MESSAGE : ZRC=0x840F0001=-2079391743=SQLO_ACCD "Access Denied"      DIA8701C Access denied for resource "", operating system return code      was "". CALLED  : OS, -, open               OSERR: EACCES (13) DATA #1 : Codepath, 8 bytes 4:11:12:24:40 DATA #2 : File name, 30 bytes /home/XXXXXXXX/sqllib/db2systm DATA #3 : SQO Open File Options, PD_TYPE_SQO_FILE_OPEN_OPTIONS, 4 bytes SQLO_REVISE, SQLO_READWRITE, SQLO_EXCLUSIVE, SQLO_WRITETHRU DATA #4 : Hex integer, 4 bytes 0x000001A0 DATA #5 : signed integer, 4 bytes 0 DATA #6 : Hex integer, 4 bytes 0x00000000 DATA #7 : String, 105 bytes Search for ossError*Analysis probe point after this log entry for further self-diagnosis of this problem. 2019-09-17-10.06.29.314523+540 I150959G1952     LEVEL: Error (OS) PID   : 26268         TID : 4096248384   PROC : test132 INSTANCE: XXXXXXXX       NODE : 000 HOSTNAME: XXXXXXXX FUNCTION: DB2 Common, OSSe, ossErrorIOAnalysis, probe:100 CALLED  : OS, -, open               OSERR: EACCES (13) DATA #1 : String, 128 bytes A total of 2 analysis will be performed :  - User info  - Path access permission  Target file = /home/XXXXXXXX/sqllib/db2systm DATA #2 : String, 188 bytes  Real user ID of current process    = 1000  Effective user ID of current process  = 1000  Real group ID of current process    = 1000  Effective group ID of current process = 1000 DATA #3 : String, 33 bytes current sbrk(0) value: 0x08093000 DATA #4 : String, 250 bytes Information of each subdirectory leading up to the first inaccessible one is shown in the format below :   :: (subdirectories)   0:0:755 (home)   1009:101:755 (XXXXXXXX)   1009:101:3775 (sqllib)   1009:101:664 (db2systm) CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol)  [0] 0xF5A89A06 pdOSSeLoggingCallback + 0x406  [1] 0xF459D13E /home/aeseb14a/sqllib/lib32/libdb2osse.so.1 + 0xD813E  [2] 0xF459E3D6 ossLogSysRC + 0x96  [3] 0xF458F092 /home/aeseb14a/sqllib/lib32/libdb2osse.so.1 + 0xCA092  [4] 0xF62AA377 sqloSystemErrorHandler + 0x7E7  [5] 0xF6213FBC sqloopenp + 0x96C  [6] 0xF5FA9668 _Z16sqlf_fix_dbm_cfgP12SQLO_FHANDLEP9sqlf_kcfdsPc + 0x278  [7] 0xF5F94FE0 _Z24sqlf_read_dbm_and_verifyP12SQLO_FHANDLEPcP9sqlf_kcfdP5sqlcai iPi + 0x560  [8] 0xF5FBAFD8 _Z8sqlfcsysP9sqlf_kcfdj + 0x1A8  [9] 0xF5DF128E _Z30sqleInitApplicationEnvironmentijjP5sqlca + 0xFFE  [10] 0xF5EFC6C6 _Z22sqleUCcheckProcessInitv + 0x96  [11] 0xF5EFC3BA sqleuApplicationInit + 0x1A  [12] 0xF5D928AF sqlastrt + 0x5F  [13] 0x0804872A ./test132 + 0x72A  [14] 0xF51D32A3 __libc_start_main + 0xF3 | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to b2 11.5 Mod 5 Fixpack 1 or higher * **************************************************************** | |
Local Fix: | |
As for -5005 error, add a write permission on db2systm file to the execution user. | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to b2 11.5 Mod 5 Fixpack 1 or higher * **************************************************************** | |
Comment | |
First fixed in Db2 11.5 Mod 5 Fixpack 1 | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 29.10.2019 17.11.2021 17.11.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |