home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

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 FixList