IBM Support

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

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

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 :
       <UID>:<GID>:<permissions> (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
    

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

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1"}]

Document Information

Modified date:
13 March 2021