IBM Support

IT30402: LINUXIA32 AND LINUXAMD64 HAVE DIFFERENT VALUES OF SQLE_LEVEL_BUILD_ID6 ON V11.1 FP4 IFIX001

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error 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 :
    &#160; &#160;<UID>:<GID>:<permissions> (subdirectories)
    
    &#160; &#160;0:0:755 (home)
    &#160; &#160;1009:101:755 (XXXXXXXX)
    &#160; &#160;1009:101:3775 (sqllib)
    &#160; &#160;1009:101:664 (db2systm)
    CALLSTCK: (Static functions may not be resolved correctly, as
    they are resolved to the nearest symbol)
    &#160; [0] 0xF5A89A06 pdOSSeLoggingCallback + 0x406
    &#160; [1] 0xF459D13E /home/aeseb14a/sqllib/lib32/libdb2osse.so.1 +
    0xD813E
    &#160; [2] 0xF459E3D6 ossLogSysRC + 0x96
    &#160; [3] 0xF458F092 /home/aeseb14a/sqllib/lib32/libdb2osse.so.1 +
    0xCA092
    &#160; [4] 0xF62AA377 sqloSystemErrorHandler + 0x7E7
    &#160; [5] 0xF6213FBC sqloopenp + 0x96C
    &#160; [6] 0xF5FA9668
    _Z16sqlf_fix_dbm_cfgP12SQLO_FHANDLEP9sqlf_kcfdsPc + 0x278
    &#160; [7] 0xF5F94FE0
    _Z24sqlf_read_dbm_and_verifyP12SQLO_FHANDLEPcP9sqlf_kcfdP5sqlcai
    iPi + 0x560
    &#160; [8] 0xF5FBAFD8 _Z8sqlfcsysP9sqlf_kcfdj + 0x1A8
    &#160; [9] 0xF5DF128E _Z30sqleInitApplicationEnvironmentijjP5sqlca +
    0xFFE
    &#160; [10] 0xF5EFC6C6 _Z22sqleUCcheckProcessInitv + 0x96
    &#160; [11] 0xF5EFC3BA sqleuApplicationInit + 0x1A
    &#160; [12] 0xF5D928AF sqlastrt + 0x5F
    &#160; [13] 0x0804872A ./test132 + 0x72A
    &#160; [14] 0xF51D32A3 __libc_start_main + 0xF3
    

Local fix

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

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Db2 11.1 Mod 4 Fixpack 6 or higher                *
    ****************************************************************
    

Problem conclusion

  • First fixed in Db2 11.1 Mod 4 Fixpack 6
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT30402

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2019-09-25

  • Closed date

    2021-03-12

  • Last modified date

    2021-03-12

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    IT30730

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • RB10 PSN

       UP

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
03 May 2022