DB2 FOR LUW / DB2FORLUW / B50 - DB2

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

****************************************************************
* USERS AFFECTED:                                              *
* ALL                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to b2 11.5 Mod 5 Fixpack 1 or higher                 *
****************************************************************

As for -5005 error, add a write permission on db2systm file to
the execution user.

****************************************************************
* USERS AFFECTED:                                              *
* ALL                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to b2 11.5 Mod 5 Fixpack 1 or higher                 *
****************************************************************

First fixed in Db2 11.5 Mod 5 Fixpack 1

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

29.10.2019
17.11.2021
17.11.2021