Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IT03955 Status: Closed

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

product:
DB2 FOR LUW / DB2FORLUW / A10 - DB2
Problem 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
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All Users                                                    * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 V101FP5 or higher version                     * 
****************************************************************
Local Fix:
Confirm there is enough memory before start up a backup command
Solution
Fixed on DB2 V101FP5 and higher version
Workaround
Confirm there is enough memory before start up a backup command
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
22.08.2014
13.07.2015
13.07.2015
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)
10.1.0.5 FixList