|
Problem IC98755
|
Status: Closed |
SEGV ENCOUNTERED DURING LOAD WHEN TABLE HAS MANY RANGE PARTITIONS DEFINED |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* USERS AFFECTED: *
* All *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 9.7 Fix Pack 10 *
**************************************************************** |
| Local Fix: |
|
| Solution |
First fixed in Version 9.7 Fix Pack 10 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 15.01.2014
10.11.2014
10.11.2014 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP10
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.10
|
 |
