IBM Support

IT03633: DB2 TRAP WHEN A BACKUP COMMAND DOESN'T GET ENOUGH MEMORY TO STARTUP

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • 1. Stack in a trap file
    
    <StackTrace>
    -------Frame------ ------Function + Offset------
    sqluMCCloseFullQues__FP13SQLUMC_IBLK_T + 0x44
    sqluMCCleanupResources__FPP13SQLUMC_IBLK_T + 0x64
    sqluMCStartBackupMediaController__FPcUi + 0xC4
    sqloEDUEntry + 0x1C
    </StackTrace>
    
    2. db2diag.log will show clear messages of "No Memory Available"
    
    2014-07-29-19.28.45.478122+480 I215056A844        LEVEL: Warning
    PID     : 19923132             TID  : 24235       PROC : db2sysc
    0
    INSTANCE: db2inst1             NODE : 000
    EDUID   : 24235                EDUNAME: db2med.25704.1 (SAMPLE)
    0
    FUNCTION: DB2 UDB, SQO Memory Management,
    SqloMemController::requestMemory, probe:50
    MESSAGE : ZRC=0x8B0F0000=-1961951232=SQLO_NOMEM "No Memory
    Available"
              DIA8300C A memory heap error has occurred.
    DATA #1 : String, 28 bytes
    Attempt to get memory failed
    DATA #2 : unsigned integer, 8 bytes
    1048576
    DATA #3 : unsigned integer, 8 bytes
    10
    DATA #4 : String, 7 bytes
    PRIVATE
    DATA #5 : unsigned integer, 8 bytes
    30867456
    DATA #6 : unsigned integer, 8 bytes
    0
    DATA #7 : unsigned integer, 8 bytes
    4724293632
    DATA #8 : unsigned integer, 8 bytes
    4724461568
    DATA #9 : unsigned integer, 8 bytes
    495255552
    
    ......
    
    2014-07-29-19.28.45.479446+480 E221032A617        LEVEL: Warning
    PID     : 19923132             TID  : 24235       PROC : db2sysc
    0
    INSTANCE: db2inst1             NODE : 000
    EDUID   : 24235                EDUNAME: db2med.25704.1 (SAMPLE)
    0
    FUNCTION: DB2 UDB, SQO Memory Management,
    sqloMemLogPoolConditions, probe:30
    DATA #1 : <preformatted>
    Out of memory failure for Private Heap on node 0.
    Requested block size           : 8784 bytes.
    Physical heap size             : 0 bytes.
    Configured heap size           : 1099511627776 bytes.
    Unreserved memory used by heap : 0 bytes.
    Unreserved memory left in set  : 0 bytes.
    
    2014-07-29-19.28.45.479849+480 I221650A503        LEVEL: Severe
    PID     : 19923132             TID  : 24235       PROC : db2sysc
    0
    INSTANCE: rpdinst1             NODE : 000
    EDUID   : 24235                EDUNAME: db2med.25704.1 (RPDMDB)
    0
    FUNCTION: DB2 UDB, database utilities,
    sqluMCStartBackupMediaController, probe:162
    MESSAGE : ZRC=0x8B0F0000=-1961951232=SQLO_NOMEM "No Memory
    Available"
              DIA8300C A memory heap error has occurred.
    DATA #1 : String, 30 bytes
    Failed to get memory for pMCib
    

Local fix

  • Confirm there is enough memory before start up a backup command
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All Users                                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 V97FP10 or higher version                     *
    ****************************************************************
    

Problem conclusion

  • Fixed on DB2 V97FP10 and higher version
    

Temporary fix

  • Confirm there is enough memory before start up a backup command
    

Comments

APAR Information

  • APAR number

    IT03633

  • 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

    2014-08-07

  • Closed date

    2014-11-24

  • Last modified date

    2014-11-24

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

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

    IT03955 IT03961

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IT03633

Modified date: 24 November 2014