|
Problem IC61576
|
Status: Geschlossen |
LOAD INTO A DATA-PARTITIONED TABLE MAY CAUSE MEMORY CORRUPTION OR TRAP IN RARE TIMING SCENARIO. |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problembeschreibung: |
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-Zusammenfassung: |
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. |
| verfügbare FixPacks: |
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
|
| Lösung |
Problem first fixed in Version v9.7 Fix Pack 1. |
| Workaround |
see LOCAL FIX |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 19.06.2009
11.03.2010
11.03.2010 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.7.FP1
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.1
|
 |
