|
Problem IC77218
|
Status: Closed |
WHEN OS RESOURCE IS EXHAUSTED, PERFORMING LOAD FROM CURSOR OPERATION(REMOTE FETCH) MAY CAUSE DB2 TRAP |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| 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 |
| Problem Summary: |
****************************************************************
* 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: |
|
| Solution |
The fix will be inclued in DB2 V9.7 Fix pack 5. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 28.06.2011
07.12.2011
07.12.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP5
|
| Problem solved according to the fixlist(s) of the following version(s) |
