DB2 - Problembeschreibung
Problem IC77218 | Status: Geschlossen |
WHEN OS RESOURCE IS EXHAUSTED, PERFORMING LOAD FROM CURSOR OPERATION(REMOTE FETCH) MAY CAUSE DB2 TRAP | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
When performing LOAD remote fetch, i.e. load data from a different database (load from cursor with the database option), sometimes OS resources could be exhausted which in turn may cause load edu failing to write to a media pipe. The trap happened when the load edu closed the pipe after the failure of writing to a media pipe. Similar entries could be found in db2diag.log: 2011-06-11-19.55.17.027617+480 I25145014626A609 LEVEL: Error PID : 2719946 TID : 1 PROC : db2lcata 0 INSTANCE: inst1 NODE : 000 APPHDL : 0-1664 APPID: 111.111.111.111.1010 AUTHID : inst1 FUNCTION: DB2 UDB, database utilities, sqluffInitPhase, probe:650 MESSAGE : ZRC=0x870F00A6=-2029059930=SQLO_NPIPE_BROKEN "Buffer too small" DATA #1 : LOADID, PD_TYPE_LOADID, 46 bytes 2531458.2011-06-11-19.55.15.273096.0 (3;48032) DATA #2 : File name, 16 bytes sqluueffServer.C DATA #3 : String, 42 bytes Error opening pipe to child's stdin stream 2011-06-11-19.55.17.059037+480 I25145033059A485 LEVEL: Error PID : 2719946 TID : 1 PROC : db2lcata 0 INSTANCE: inst1 NODE : 000 APPHDL : 0-1664 APPID: 111.111.111.111.1010 AUTHID : inst1 FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh, probe:1 MESSAGE : Error in agent servicing application with coor_node: DATA #1 : Hexdump, 2 bytes 0x0FFFFFFFFFFF3960 : 0000 Call Stack may look like the following: sqluffInitPhase iRun sqlusSubAgentRouter sqleSubRequestRouter sqleProcessSubRequest sqleRunAgent sqloCreateEDU sqloSpawnEDU sqleCreateNewAgent sqleGetAgentFromPool sqleGetAgent sqlcctcpconnmgr sqloCreateEDU sqloSpawnEDU | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * When performing LOAD remote fetch, i.e. load data from a * * * * different database (load from cursor with the database * * option), * * sometimes OS resources could be exhausted which in turn may * * * * cause load edu failing to write to a media pipe. The trap * * * * happened when the load edu closed the pipe after the failure * * of * * writing to a media pipe. * * * * * * * * Similar entries could be found in db2diag.log: * * * * * * * * 2011-06-11-19.55.17.027617+480 I25145014626A609 LEVEL: * * Error * * PID : 2719946 TID : 1 PROC : * * * * db2lcata 0 * * * * INSTANCE: inst1 NODE : 000 * * * * APPHDL : 0-1664 APPID: 111.111.111.111.1010 * * * * AUTHID : inst1 * * * * FUNCTION: DB2 UDB, database utilities, sqluffInitPhase, * * * * probe:650 * * * * MESSAGE : ZRC=0x870F00A6=-2029059930=SQLO_NPIPE_BROKEN * * "Buffer * * too small" * * * * DATA #1 : LOADID, PD_TYPE_LOADID, 46 bytes * * * * 2531458.2011-06-11-19.55.15.273096.0 (3;48032) * * * * DATA #2 : File name, 16 bytes * * * * sqluueffServer.C * * * * DATA #3 : String, 42 bytes * * * * Error opening pipe to child's stdin stream * * * * * * * * 2011-06-11-19.55.17.059037+480 I25145033059A485 LEVEL: * * Error * * PID : 2719946 TID : 1 PROC : * * * * db2lcata 0 * * * * INSTANCE: inst1 NODE : 000 * * * * APPHDL : 0-1664 APPID: 111.111.111.111.1010 * * * * AUTHID : inst1 * * * * FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh, * * * * probe:1 * * * * MESSAGE : Error in agent servicing application with * * coor_node: * * DATA #1 : Hexdump, 2 bytes * * * * 0x0FFFFFFFFFFF3960 : 0000 * * * * * * * * * * * * Call Stack may look like the following: * * * * * * * * sqluffInitPhase * * * * iRun * * * * sqlusSubAgentRouter * * * * sqleSubRequestRouter * * * * sqleProcessSubRequest * * * * sqleRunAgent * * * * sqloCreateEDU * * * * sqloSpawnEDU * * * * sqleCreateNewAgent * * * * sqleGetAgentFromPool * * * * sqleGetAgent * * * * sqlcctcpconnmgr * * * * sqloCreateEDU * * * * sqloSpawnEDU * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 V9.7 Fix pack 5. * **************************************************************** | |
Local-Fix: | |
Lösung | |
The fix will be inclued in DB2 V9.7 Fix pack 5. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 28.06.2011 07.12.2011 07.12.2011 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP5 | |
Problem behoben lt. FixList in der Version |