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 |