DB2 - Problembeschreibung
Problem IC77913 | Status: Geschlossen |
DB2 CRASHES WHILE LOADING INTO THE FACT 'PARTITIONED BY' TABLE WITH AT LEAST ONE PARTITION DETACHED. | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 | |
Problembeschreibung: | |
db2 crash each time when trying to load into a table, if : - Range Partition (RP) table, with at least one detached range - Compression enabled, and at least one of the ranges missing dictionary - LOAD INSERT - Detach partition in any tablespace configuration will hit the problem. - You are using IBM DB2 v95fp7 (and beyond). It is not present in v97 any fixpack and is not present in v95fp6 and before that. In this case LOAD will try to create a dictionary. During that it will attempt to access structures for partition that does not exist. So we panic on NULL dereference. STACK Generated : 0 sqluCTable::RefreshBMPFixCB 1 sqlulAdcTableScanner 2 sqluCTableScanner::iRun 3 sqluLoadEDUDriver 4 sqloEDUEntry | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * Users using IBM DB2 v95fp7 (and beyond). It is not present * * in v97 any fixpack and is not present in v95fp6 and before. * * that. * **************************************************************** * PROBLEM DESCRIPTION: * * db2 crash each time when trying to load into a table, if : * * * * - Range Partition (RP) table, with at least one detached * * range * * * * - Compression enabled, and at least one of the ranges * * missing * * dictionary * * * * - LOAD INSERT * * * * - Detach partition in any tablespace configuration will hit * * the * * problem. * * * * - You are using IBM DB2 v95fp7 (and beyond). It is not * * present * * in v97 any fixpack and is not present in v95fp6 and before * * that. * * * * In this case LOAD will try to create a dictionary. During * * that * * it will attempt to access structures for partition that does * * not * * exist. So we panic on NULL dereference. * * * * STACK Generated : * * * * 0 sqluCTable::RefreshBMPFixCB * * 1 sqlulAdcTableScanner * * 2 sqluCTableScanner::iRun * * 3 sqluLoadEDUDriver * * 4 sqloEDUEntry * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 v95fp9 * **************************************************************** | |
Local-Fix: | |
Any of the following operation can be used to work around the problem: 1. Fill in "detached gaps" in RP table. For all partitions that are detached, finalize index cleanup (can be seen via LIST UTILITIES), and then add dummy partition (via ALTER TABLE ADD PARTITION) that does not hold any data. The idea is to fill in all gaps in partition ids - see DATAPARTITIONID column from SYSCAT.DATAPARTITIONS output. 2. Disable compression for duration of LOAD. That way LOAD will not try to build dictionary, and avoid erroneous codepath. ALTER TABLE COMPRESS NO LOAD INSERT ALTER TABLE COMPRESS YES 2a. Alternatively, create dictionaries for all defined ranges. That way LOAD will not try to create one. However, all ranges (even empty ones) have to have a dictionary! 3. Avoid LOAD in the first place. IMPORT command should be executed from client located on the server, to improve performance. EXPORT TO stage.ixf OF IXF SELECT * FROM <cursorname> IMPORT FROM stage.ixf OF IXF INSERT INTO <tablename> | |
verfügbare FixPacks: | |
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows | |
Lösung | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 04.08.2011 08.03.2012 08.03.2012 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.5.FP9 | |
Problem behoben lt. FixList in der Version | |
9.5.0.9 |