IBM Support

IC84208: SOMETIMES A CALL TO AN AUTONOMOUS PROCEDURE MAY FAIL WITH : SQL0083C A MEMORY ALLOCATION ERROR HAS OCCURRED

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Sometimes a call to an Autonomous procedure may fail with :
    SQL0083C  A memory allocation error has occurred.
    
    Db2diag.log will show error like :
    --------------------------------------
    
    2012-06-01-09.30.56.257000+330 I1900F1880         LEVEL: Warning
    PID     : 10664                TID  : 5956        PROC :
    db2syscs.exe
    INSTANCE: DB2                  NODE : 000         DB   : SAMPLE
    APPHDL  : 0-1556               APPID: *LOCAL.DB2.120601040056
    AUTHID  : ADMINISTRATOR
    EDUID   : 5956                 EDUNAME: db2agent (SAMPLE) 0
    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
    0x000007fffcf30af8
    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 : Pointer to address that will be set by new allocation,
    PD_TYPE_PTR_TO_ADDRESS_OUT, 8 bytes
    0x000007fffe076be0
    DATA #8 : File name, PD_TYPE_OSS_MEM_FILE_NAME, 10 bytes
    sqleseti.C
    DATA #9 : Line of code, PD_TYPE_OSS_MEM_LINE_NUM, 8 bytes
    904
    DATA #10: Resource binding pointer,
    PD_TYPE_RESOURCE_BINDING_PTR, 8 bytes
    0x0000000000000000
    CALLSTCK:
      [0] 0x0000000180108F93 pdLog + 0x355
      [1] 0x000000018004C732 sqlogmblkEx + 0x102E
      [2] 0x000000000426F331 sqleCopySQLSetInfo + 0x6D
      [3] 0x00000000020B221C
    sqlerAutonomousRoutine::InitializeAutonomousSession + 0x1DE
      [4] 0x00000000020B1F3D sqlerAutonomousSession + 0x49
      [5] 0x0000000002079C2C sqleIndCoordProcessRequest + 0x78E
      [6] 0x0000000001FF9591 sqeAgent::RunEDU + 0x2E5
      [7] 0x0000000003A7AFCF sqlzRunEDU + 0x111
      [8] 0x00000001800E4363 sqloInitEDUServices + 0x42B
      [9] 0x000000007742652D BaseThreadInitThunk + 0xD
    
    2012-06-01-09.30.56.494000+330 I3782F578          LEVEL: Error
    PID     : 10664                TID  : 5956        PROC :
    db2syscs.exe
    INSTANCE: DB2                  NODE : 000         DB   : SAMPLE
    APPHDL  : 0-1556               APPID: *LOCAL.DB2.120601040056
    AUTHID  : ADMINISTRATOR
    EDUID   : 5956                 EDUNAME: db2agent (SAMPLE) 0
    FUNCTION: DB2 UDB, routine_infrastructure,
    sqlerAutonomousRoutine::InitializeAutono, probe:997
    MESSAGE : ZRC=0x820F0004=-2112946172=SQLO_MEM_SIZE "Mem Mgt
    invalid size"
              DIA8563C An invalid memory size was requested.
    
    
    
    DB2 trace will show :
    --------------------------
    
    11610       | | | | | | | | | | | | | | | | |
    sqlerAutonomousInvoker exit [rc = 0x820F0004 = -2112946172 =
    SQLO_MEM_SIZE]
    11611       | | | | | | | | | | | | | | | | | sqlzeMapZrc entry
    [eduid 19 eduname db2agent]
    11612       | | | | | | | | | | | | | | | | | | sqlzGetZRCInfo
    entry [eduid 19 eduname db2agent]
    11613       | | | | | | | | | | | | | | | | | | sqlzGetZRCInfo
    exit [rc = 0xFFFFFFAD = -83]
    11614       | | | | | | | | | | | | | | | | | |
    sqlzeStoreFuncName entry [eduid 19 eduname db2agent]
    11615       | | | | | | | | | | | | | | | | | |
    sqlzeStoreFuncName data [probe 1]
    11616       | | | | | | | | | | | | | | | | | |
    sqlzeStoreFuncName exit
    11617       | | | | | | | | | | | | | | | | | | sqlzelsc entry
    [eduid 19 eduname db2agent]
    11618       | | | | | | | | | | | | | | | | | | sqlzelsc data
    [probe 1]
    11619       | | | | | | | | | | | | | | | | | | sqlzelsc exit
    11620       | | | | | | | | | | | | | | | | | | sqlrr_dump_ffdc
    entry [eduid 19 eduname db2agent]
    11621       | | | | | | | | | | | | | | | | | | sqlrr_dump_ffdc
    exit
    11622       | | | | | | | | | | | | | | | | | |
    pdInvokeCatchInterface entry [eduid 19 eduname db2agent]
    11623       | | | | | | | | | | | | | | | | | |
    pdInvokeCatchInterface data [probe 10]
    11624       | | | | | | | | | | | | | | | | | |
    pdInvokeCatchInterface exit
    11625       | | | | | | | | | | | | | | | | | sqlzeMapZrc
    errtrans [probe 40] [ ZRC = 0x820F0004 = -2112946172 =
    SQLO_MEM_SIZE -->  SQL0083  ]
    11626       | | | | | | | | | | | | | | | | | sqlzeMapZrc error
    [probe 50] [ ZRC = 0x820F0004 = -2112946172 = SQLO_MEM_SIZE]
    

Local fix

  • This can be avoided by executing a "db2 connect reset" after
    defining the procedure, and then re-establishing the connection
    before calling the procedure.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All users on DB2 V9.7 FixPack 6 and below.                   *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 V9.7 FiXPack 7 or higher FixPack.             *
    ****************************************************************
    

Problem conclusion

  • Problem first fixed in Db2 V9.7 FixPack 7.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC84208

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-06-13

  • Closed date

    2012-10-25

  • Last modified date

    2012-10-25

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

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

    IC88316

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSY

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC84208

Modified date: 25 October 2012