|
Problem IC77003
|
Status: Closed |
WHEN OS RESOURCE IS EXHAUSTED, PERFORMING LOAD FROM CURSOR OPERATION(remote fetch) MAY CAUSE DB2 TRAP |
| product: |
DB2 FOR LUW / DB2FORLUW / 910 - 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 version 9.1 fix pack 11. *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 9.1 Fix Pack 11 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12 for Linux, UNIX and Windows
|
| Solution |
The fix will be included in DB2 version 9.1 fix pack 11. |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC77217 IC77218
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 16.06.2011
07.12.2011
07.12.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.1.FP11
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.1.0.11
|
 |
