DB2 - Problembeschreibung
Problem IC98755 | Status: Geschlossen |
SEGV ENCOUNTERED DURING LOAD WHEN TABLE HAS MANY RANGE PARTITIONS DEFINED | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
Segv can be encountered while processing a load that is operating on a range partitioned table. The segv can occur in both normal load processing, as well as during replay of load during crash recovery. Segv will only occur if there are greater than 1070 objects defined in the range partitioned table. The number of objects for a table varies depending on the definition of the range partitioned table. The multiplier can be determined by adding the following +1 for the base table +1 if there is at least one partitioned index defined +1 if the table includes long varchar columns +1 if the table uses organize by clause (MDC) +1 if the table includes XML columns +2 if the table includes LOB columns The number of objects is the multiplier times the number of ranges defined in the partition by range clause of the create table statement. When the segv is encountered, the db2diag.log will contain the following entry 2014-01-14-00.15.30.468082+480 I37308E513 LEVEL: Warning PID : 20695 TID : 140736964060928PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 DB : SAMPLE APPHDL : 0-54 APPID: *N00.db2inst1.140113154903 AUTHID : DB2INST1 EDUID : 53 EDUNAME: db2redom (HNDB) 42 FUNCTION: DB2 UDB, RAS/PD component, pdEDUIsInDB2KernelOperation, probe:600 DATA #1 : String, 35 bytes _Z30sqlu_process_pending_operation DATA #2 : String, 4 bytes sqlu The corresponding trap file will include this stack 0 ossDumpStackTraceEx 1 OSSTrapFile::dumpEx 2 sqlo_trce 3 sqloEDUCodeTrapHandler 4 __PRETTY_FUNCTION__.6775 5 memcpy 6 _intel_fast_memcpy.A 7 sqlu_process_pending_operation 8 sqlptppl 9 sqlpRFWppl 10 sqlpRecDbRedo 11 sqlprProcDPSrec 12 sqlpPRecReadLog 13 sqlpParallelRecovery 14 sqleSubCoordProcessRequest 15 sqeAgent::RunEDU 16 sqzEDUObj::EDUDriver 17 sqlzRunEDU 18 sqloEDUEntry 19 _L_mutex_lock_3503 20 clone | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * All * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 9.7 Fix Pack 10 * **************************************************************** | |
Local-Fix: | |
Lösung | |
First fixed in Version 9.7 Fix Pack 10 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 15.01.2014 10.11.2014 10.11.2014 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP10 | |
Problem behoben lt. FixList in der Version | |
9.7.0.10 |