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 |
|