DB2 - Problem description
Problem IC74403 | Status: Closed |
SPECIFIC OUT-OF-MEMORY FAILURE DURING LOAD | |
product: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problem description: | |
Abstract: In rare condition, a specific out-of-memory failure during Load (into a table with indexes) may cause a seg-fault. Description: If an out of memory failure occurs at a very specific time during Load initialization (specifically when sorting infrastructure is being initialized for index key maintanance), a trap/segfault may occur. Symptoms include a db2diag.log entry similar to this: 2011-01-17-13.45.06.866092-360 I6106025A533 LEVEL: Error PID : 1372212 TID : 15729 PROC : db2sysc 5 INSTANCE: db2admn1 NODE : 005 DB : DB2CSA APPHDL : 0-15469 APPID: 10.251.116.128.61577.1101171944 AUTHID : ECSDMETL EDUID : 15729 EDUNAME: db2lfrm0 5 FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0 DATA #1 : String, 111 bytes LOADID: 46650.2011-01-17-13.44.23.650025.0 (5622;4) , -1961951227, 0, Detected in file:sqluDMSort.C, Line:1189 and a trap file with a stack that contains the following functions: <stack> sqluDMSortInit squInitLoadSort sqluRidderSingleFormatterSetup sqluFormatterSetup sqluldat sqloEDUEntry Workaround: none | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * DB2 LUW 9.7 FP4 and below * **************************************************************** * PROBLEM DESCRIPTION: * * Abstract: * * In rare condition, a specific out-of-memory failure during * * Load * * (into a table with indexes) may cause a seg-fault. * * * * Description: * * If an out of memory failure occurs at a very specific time * * during Load initialization (specifically when sorting * * infrastructure is being initialized for index key * * maintanance), * * a trap/segfault may occur. * * * * Symptoms include a db2diag.log entry similar to this: * * 2011-01-17-13.45.06.866092-360 I6106025A533 LEVEL: * * Error * * PID : 1372212 TID : 15729 PROC : * * db2sysc * * 5 * * INSTANCE: db2admn1 NODE : 005 DB : * * DB2CSA * * APPHDL : 0-15469 APPID: * * 10.251.116.128.61577.1101171944 * * AUTHID : ECSDMETL * * EDUID : 15729 EDUNAME: db2lfrm0 5 * * FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0 * * DATA #1 : String, 111 bytes * * LOADID: 46650.2011-01-17-13.44.23.650025.0 (5622;4) * * , -1961951227, 0, Detected in file:sqluDMSort.C, Line:1189 * * * * and a trap file with a stack that contains the following * * functions: * * <stack> * * sqluDMSortInit * * squInitLoadSort * * sqluRidderSingleFormatterSetup * * sqluFormatterSetup * * sqluldat * * sqloEDUEntry * * * * Workaround: * * none * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 LUW 9.7 FP5 * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 10.02.2011 03.10.2013 03.10.2013 |
Problem solved at the following versions (IBM BugInfos) | |
9.7.FP5 | |
Problem solved according to the fixlist(s) of the following version(s) |