DB2 FOR LUW / DB2FORLUW / 980 - DB2

INSTANCE HANG WHEN RUNNING REDISTRIBUTE DATABASE PARTITION GROUP 
 
COMMAND WHICH RECREATE INDEX AND COLLECT STATISTICS INTERNALLY. 
 
Specific to encounter this scenario: 
-- create table 
-- create index on the table 
-- runstats on the table with distribution and index option, at 
least one of the column with distribution stats collected is 
subset of the index key 
-- redistribute database partition group command on the table, 
i.e. this scenario is specific to  Database Partitioning Feature 
(DPF) environments 
 
Sample of the stack trace: 
<StackTrace> 
-------Frame------ ------Function + Offset------ 
0x0900000004496DD8 PickVictimBucket__12sqli_hist_waFv + 0x70 
0x0900000004496604 AddValue__12sqli_hist_waFP13sqldDistValue + 
0x1E8 
0x0900000004495F40 sqliGatherDistStats__FP9schs_datai + 0xE0 
0x0900000004490B4C @145@gather__FP9schs_dataP7SQLI_CB + 0xA68 
0x0900000004A943E0 sqliProcessColStats__FP9schs_dataP7SQLI_CBPUi 
+ 0xE4 
0x09000000051A2CE0 
@145@sqliCriStats__FP7SQLI_CBP14SQLI_PAGE_DESC + 0xE4 
0x09000000051A1A08 
@145@sqliPageComplete__FP7SQLI_CBP6CRI_CBP6ACT_PGP14SQLI_PAGE_DE 
SC 
+ 0x160 
0x090000000519C9B0 
@145@sqliGetNewPage__FP7SQLI_CBP6CRI_CBP8REC_INFOiUs + 0xC84 
0x0900000005196314 sqliCIBuildPage__FP11SQLD_CRI_CB + 0x7B0 
0x09000000051C62C8 sqlurRedistIndexCreate__FP11SQLD_CRI_CBPc + 
0x160 
0x09000000051BB7B8 
@145@sqlicris__FP8sqeAgentPcPP10SQLD_VALUEP8REC_INFOP7SQLI_CB + 
0x514 
0x09000000051B9B38 
sqlicri__FP8sqeAgentP8SQLD_TCBP16SQLB_OBJECT_DESCP15SQLI_SUBAGNT 
_CBPcPP10SQLD_VALUEP17SQLD_CREATEINX_CBP9SQLD_IXCB 
+ 0 
x13D0 
0x09000000051D9E5C 
zRebuild__18sqlucCIndexWrapperFP22sqlucIIndexKeyIteratorP10sqlo_ 
latchUcP10SQLD_TSTATPP10SQLD_ISTATiPiT2P8SQLP_LSN 
+ 0x 
348 
0x09000000051D949C 
zFlushInternal__36sqlucCSortedIncrementalIndexStrategyFb + 0x75C 
0x09000000051DC140 
zCompleteStrategy__36sqlucCSortedIncrementalIndexStrategyFv + 
0x2C 
</StackTrace>

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* INSTANCE HANG WHEN RUNNING REDISTRIBUTE DATABASE             * 
* PARTITIONGROUPCOMMAND WHICH RECREATE INDEX AND COLLECT       * 
* STATISTICSINTERNALLY.Specific to encounter this scenario:--  * 
* create table-- create index on the table-- runstats on the   * 
* table with distribution and index option,atleast one of the  * 
* column with distribution stats collected issubset of the     * 
* index key-- redistribute database partition group command on * 
* thetable,i.e. this scenario is specific to  Database         * 
* PartitioningFeature(DPF) environmentsSample of the stack     * 
* trace:<StackTrace>-------Frame------ ------Function +        * 
* Offset------0x0900000004496DD8                               * 
* PickVictimBucket__12sqli_hist_waFv + 0x700x0900000004496604  * 
* AddValue__12sqli_hist_waFP13sqldDistValue+0x1E80x0900000004495 
* sqliGatherDistStats__FP9schs_datai + 0xE00x0900000004490B4C  * 
* @145@gather__FP9schs_dataP7SQLI_CB                           * 
* +0xA680x0900000004A943E0sqliProcessColStats__FP9schs_dataP7SQL 
* 0xE40x09000000051A2CE0@145@sqliCriStats__FP7SQLI_CBP14SQLI_PAG 
* +                                                            * 
* 0xE40x09000000051A1A08@145@sqliPageComplete__FP7SQLI_CBP6CRI_C 
* 0x1600x090000000519C9B0@145@sqliGetNewPage__FP7SQLI_CBP6CRI_CB 
* + 0xC840x0900000005196314 sqliCIBuildPage__FP11SQLD_CRI_CB + * 
* 0x7B00x09000000051C62C8                                      * 
* sqlurRedistIndexCreate__FP11SQLD_CRI_CBPc+0x1600x09000000051BB 
* 0x13D00x09000000051D9E5CzRebuild__18sqlucCIndexWrapperFP22sqlu 
* 0x3480x09000000051D949CzFlushInternal__36sqlucCSortedIncrement 
* +0x75C0x09000000051DC140zCompleteStrategy__36sqlucCSortedIncre 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 V9.8 FP3                                      * 
****************************************************************

To workaround this issue, you may change the runstats command to 
NOT to include "with distribution" clause before the 
REDISTRIBUTE step. 
After the REDISTRIBUTE step, you may issue runstats to collect 
distribution stats manually.

DB2 Version 9.8 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 9.8 Fix Pack 4 for AIX and Linux
 DB2 Version 9.8 Fix Pack 5 for AIX and Linux
 

This APAR is first fixed in DB2 V9.8 FP3

keiner bekannt / siehe Local-Fix

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

09.03.2010
17.01.2011
17.01.2011

9.8.FP3