home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
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 IT03633 Status: Closed

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

product:
DB2 FOR LUW / DB2FORLUW / 970 - 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 V97FP10 or higher version                     * 
****************************************************************
Local Fix:
Confirm there is enough memory before start up a backup command
Solution
Fixed on DB2 V97FP10 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       :
07.08.2014
24.11.2014
24.11.2014
Problem solved at the following versions (IBM BugInfos)
9.7.FP10
Problem solved according to the fixlist(s) of the following version(s)
9.7.0.10 FixList