|
Problem IC67038
|
Status: Closed |
INSTANCE HANG WHEN RUNNING REDISTRIBUTE COMMAND WHICH RECREATE INDEX AND COLLECT STATISTICS INTERNALLY |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
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> |
| Problem Summary: |
****************************************************************
* 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.7 FixPack2. *
**************************************************************** |
| Local Fix: |
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. |
| available fix packs: |
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
This APAR is first fixed in DB2 V9.7 FixPack2. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 09.03.2010
02.07.2010
02.07.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.2
|
 |
