IBM Support

IT21509: HASH FUNCTION FOR EMPTY BLOB RETURNS SQL0083C ERROR

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Calling HASH function on an empty blob returns SQL0083C error:
    $ db2 "values hash( blob(''), 2 )"
    SQL0083C  A memory allocation error has occurred.
    
    The following is logged in db2diag.log:
    2017-07-17-21.05.23.674784-240 I1553866A2599        LEVEL:
    Warning
    PID     : 36634966             TID : 2332           PROC :
    db2sysc
    INSTANCE: hbwang               NODE : 000           DB   : DB11
    APPHDL  : 0-28                 APPID: *LOCAL.hbwang.170717232912
    AUTHID  : HBWANG               HOSTNAME: panipuri
    EDUID   : 2332                 EDUNAME: db2agent (DB11)
    FUNCTION: DB2 UDB, SQO Memory Management, sqlogmblkEx,
    probe:1000
    MESSAGE : ZRC=0x820F0004=-2112946172=SQLO_MEM_SIZE "Mem Mgt
    invalid size"
              DIA8563C An invalid memory size was requested.
    DATA #1 : String, 43 bytes
    Memory management block allocation failure.
    DATA #2 : Codepath, 8 bytes
    2
    DATA #3 : Memory pool handle pointer,
    PD_TYPE_MEM_POOL_HANDLE_PTR, 8 bytes
    0x0a00020000003398
    DATA #4 : Requested size, PD_TYPE_MEM_REQUESTED_SIZE, 8 bytes
    0
    DATA #5 : Adjusted block size, PD_TYPE_MEM_ADJUSTED_SIZE, 8
    bytes
    0
    DATA #6 : Options for requested block, PD_TYPE_GET_MEM_OPTIONS,
    4 bytes
    0x00000000
    DATA #7 : File name, PD_TYPE_OSS_MEM_FILE_NAME, 17 bytes
    sqlri_hash_sclr.C
    DATA #8 : Line of code, PD_TYPE_OSS_MEM_LINE_NUM, 8 bytes
    652
    DATA #9 : Resource binding pointer,
    PD_TYPE_RESOURCE_BINDING_PTR, 8 bytes
    0x0000000000000000
    CALLSTCK: (Static functions may not be resolved correctly, as
    they are resolved to the nearest symbol)
      [0] 0x090000008D988C9C sqloGetMemoryBlockExtended + 0x41C
      [1] 0x0900000093FC1250 sqlriHashLong__FP8sqlrr_cb + 0x350
      [2] 0x09000000905C53B8 sqlriComputeOnce__FP8sqlrr_cb + 0xB8
      [3] 0x090000008F878878
    sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm + 0x5F8
      [4] 0x090000008F32D628
    sqlrr_process_fetch_request__FP14db2UCinterface + 0xD08
      [5] 0x090000008F3309A8
    sqlrr_open__FP14db2UCinterfaceP15db2UCCursorInfo + 0x10C8
      [6] 0x0900000094721140
    sqljs_ddm_opnqry__FP14db2UCinterfaceP13sqljDDMObject + 0x4C0
      [7] 0x09000000946BFB78
    sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC
    interface + 0x298
      [8] 0x09000000946C2BD0
    sqljsParse__FP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb +
    0x2250
      [9] 0x090000009468F04C
    IPRA.$sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb + 0xEAC
      [10] 0x0900000094697B14
    sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0xB4
      [11] 0x090000009468D0F0
    IPRA.$sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x13F0
      [12] 0x090000009468A534
    sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T + 0x334
      [13] 0x090000008DA95CA0 RunEDU__8sqeAgentFv + 0xB60
      [14] 0x090000008DA787A0 EDUDriver__9sqzEDUObjFv + 0x2E0
      [15] 0x090000008D968714 sqloEDUEntry + 0x374
      [16] 0x0900000000573FE8 _pthread_body + 0xE8
      [17] 0xFFFFFFFFFFFFFFFC ?unknown + 0xFFFFFFFF
    

Local fix

  • N/A
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Db2 11.1 Mod 3 Fix Pack 3 or higher               *
    ****************************************************************
    

Problem conclusion

  • First fixed in Db2 11.1 Mod 3 Fix Pack 3
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT21509

  • 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

    2017-07-18

  • Closed date

    2018-03-19

  • Last modified date

    2018-03-19

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

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

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • RB10 PSN

       UP

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

Document Information

Modified date:
19 March 2018