DB2 - Problembeschreibung
Problem IC67038 | Status: Geschlossen |
INSTANCE HANG WHEN RUNNING REDISTRIBUTE COMMAND WHICH RECREATE INDEX AND COLLECT STATISTICS INTERNALLY | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
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-Zusammenfassung: | |
**************************************************************** * 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. | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows | |
Lösung | |
This APAR is first fixed in DB2 V9.7 FixPack2. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 09.03.2010 02.07.2010 02.07.2010 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7. | |
Problem behoben lt. FixList in der Version | |
9.7.0.2 |