|
Problem IC61576
|
Status: Closed |
LOAD INTO A DATA-PARTITIONED TABLE MAY CAUSE MEMORY CORRUPTION OR TRAP IN RARE TIMING SCENARIO. |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
The Load utility, when invoked against a data-partitioned table,
in rare timing scenarios may cause memory corruption and lead to
eventual trap or panic.
External symptoms often differ, some possible symptoms are
db2diag.log errors containing 'SQLB_EMP_INDIRECT_NOT_FOUND':
2008-02-18-18.53.07.854842-300 I760959E453 LEVEL: Error
PID : 23154 TID : 183041501440PROC :
db2lbm18 4
INSTANCE: nypxt230 NODE : 004 DB :
RAVECR_1
APPHDL : 1-970 APPID:
10.163.73.204.9365.080218234417
AUTHID : MSDB2
FUNCTION: DB2 UDB, buffer pool services, sqlbFixDataEMP,
probe:830
MESSAGE : ZRC=0x84020019=-2080243687=SQLB_EMP_INDIRECT_NOT_FOUND
"EMP INDIRECT NOT FOUND"
Other symptoms include traditional memory corruption type error
messages.
.
The following stack traceback has been seen when the LOAD
EDU db2lbm process abends with a SIGSEGV due to this issue:
.
- Stack:
.
0 ossDumpStackTrace
1 OSSTrapFile::dump
2 sqlo_trce
3 sqloEDUCodeTrapHandler
4 __res_state
5 sqluWriteBufToDB
6 sqlulBMCont
7 sqlulbuf
8 sqloCreateEDU
9 sqloSpawnEDU
10 sqlulInitOneEDU
11 sqlulInitNBM
12 sqlulCreateQAndEDU
13 sqluvload
14 call_sqluvload
15 sqluLoadPartition
16 sqlusCLoadSubAgent::iRun
17 sqlusSubAgentRouter
18 sqleSubRequestRouter
19 sqleProcessSubRequest
20 sqleRunAgent
21 sqloCreateEDU
22 sqloSpawnEDU
23 sqleCreateNewAgent
24 sqleGetAgentFromPool
25 sqleGetAgent
26 sqlccipcconmgr_process_conn
27 sqlccipcconnmgr_child
28 sqloCreateEDU
29 sqloSpawnEDU
30 sqlccipcconnmgr
31 sqleInitSysCtlr
32 sqleSysCtlr
33 sqloSystemControllerMain
34 sqloRunInstance
35 DB2main
36 main
37 __libc_start_main
38 sqlePdbProcessRequest
.
This problem is not specific to DPF or any particular Load
options, expect that the target table is data-partitioned. |
| Problem Summary: |
USERS AFFECTED: ALL
PROBLEM DESCRIPTION: please refer to the ERROR DESCRIPTION
PROBLEM SUMMARY: please refer to the ERROR DESCRIPTION |
| Local Fix: |
None. Use IMPORT utility instead. |
| available fix packs: |
DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
Problem first fixed in Version v9.7 Fix Pack 1. |
| Workaround |
see LOCAL FIX |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 19.06.2009
11.03.2010
11.03.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP1
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.1
|
 |
