IBM Support

IC88316: 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 V10 FixPack 1 or below.                     *
    ****************************************************************
    * PROBLEM 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] *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 V10 FixPack 2 or above.                       *
    ****************************************************************
    

Problem conclusion

  • Problem first fixed in DB2 V10 FixPack 2.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC88316

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-11-17

  • Closed date

    2012-12-19

  • Last modified date

    2012-12-19

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

    IC84208

  • 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

  • RA10 PSY

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
19 December 2012