DB2 FOR LUW / DB2FORLUW / A10 - DB2

Once you execute concurrent REORG operations like: 
db2 "reorg table T1 allow no access on data partition PART0" 
db2 "reorg table T1 allow no access on data partition PART1" 
 
on table T1 meting criteria required for parallel reorg, you may 
notice that IdxRecreat phase is being sequential. 
The problem is caused by latching during the processing what 
prevents parallel execution. 
 
The problem can only be hit when INTRA_PARALLEL is turned on or 
when using database partitioning feature. 
 
Observable symptoms: 
1. You might notice unexpected difference between REORG finish 
times for partitions similar in size by observing REORG command 
finish time or db2pd -reorg output. 
2. You might notice in db2top output that only one REORG at the 
time utilizes IO, while REORG for other partitions are idle. 
3. In stacks collected during the issue occurrence, you can 
notice that one REORG thread is holding 
SQLO_LT_SQLD_TCB__loadInProgress latch, while other parallel 
threads are waiting for the latch in subject.

**************************************************************** 
* USERS AFFECTED:                                              * 
* INTRA_PARALLEL ON or when using DPF                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 version 10.1.0.5.                             * 
****************************************************************

The problem is first fixed in DB2 version 10.1.0.5.

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

11.04.2014
14.07.2015
14.07.2015