DB2 - Problem description
Problem IC74372 | Status: Closed |
SPECIFIC OUT-OF-MEMORY FAILURE DURING LOAD | |
product: | |
DB2 FOR LUW / DB2FORLUW / 950 - 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: xxxxx NODE : 005 DB : xxxx APPHDL : 0-15469 APPID: xxxx.61577.1101171944 AUTHID : xxxxx 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: * * All * **************************************************************** * 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: * * Update to next fixpak where APAR is contained. * **************************************************************** | |
Local Fix: | |
available fix packs: | |
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows | |
Solution | |
Workaround | |
not known / see Local fix | |
BUG-Tracking | |
forerunner : APAR is sysrouted TO one or more of the following: IC74400 IC74403 follow-up : | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 09.02.2011 08.07.2011 08.07.2011 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) | |
9.5.0.8 |