home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC76448 Status: Geschlossen

INSERT OR UPDATE WITH INDEX COMPRESSION AND PAGE SPLIT HIGH/LOW MAY CAUSE
CRASH DURINGINDEX PAGE SPLIT

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
If the indexes for a table are compressed and were created with 
the PAGE SPLIT HIGH or PAGE SPLIT LOW clause, then any of the 
following operations can cause a crash: 
- INSERT 
- UPDATE 
- IMPORT (with the INSERT option) 
- LOAD (with the INDEXING MODE INCREMENTAL or INDEXING MODE 
AUTOSELECT options) 
 
The following are example db2diag.log for the crash: 
 
2011-05-17-12.22.23.341693-240 I23888A517         LEVEL: Severe 
PID     : 28180562             TID  : 1838        PROC : db2sysc 
INSTANCE: dbuser               NODE : 000         DB   : WSDB 
APPHDL  : 0-49                 APPID: *LOCAL.dbuser.110517162100 
AUTHID  : DBUSER 
EDUID   : 1838                 EDUNAME: db2agent (WSDB) 
FUNCTION: DB2 UDB, index manager, sqlisplt, probe:600 
MESSAGE : Split failed to make room! 
DATA #1 : Hexdump, 4 bytes 
0x070000000E3F5A78 : 0000 0004 .... 
 
2011-05-17-12.22.23.342299-240 I24406A515         LEVEL: Severe 
PID     : 28180562             TID  : 1838        PROC : db2sysc 
INSTANCE: dbuser               NODE : 000         DB   : WSDB 
APPHDL  : 0-49                 APPID: *LOCAL.dbuser.110517162100 
AUTHID  : DBUSER 
EDUID   : 1838                 EDUNAME: db2agent (WSDB) 
FUNCTION: DB2 UDB, index manager, sqlisplt, probe:1300 
RETCODE : ZRC=0x87090054=-2029453228=SQLI_PRG_ERR "Program 
error" DIA8575C An index manager programming error occurred.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All users                                                    * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* If the indexes for a table are compressed and were created   * 
* with the PAGE SPLIT HIGH or PAGE SPLIT LOW clause, then any  * 
* of the following operations can cause a crash:               * 
* - INSERT                                                     * 
* - UPDATE                                                     * 
* - IMPORT (with the INSERT option)                            * 
* - LOAD (with the INDEXING MODE INCREMENTAL or INDEXING MODE  * 
* AUTOSELECT options)                                          * 
*                                                              * 
* The following are example db2diag.log for the crash:         * 
*                                                              * 
* 2011-05-17-12.22.23.341693-240 I23888A517        LEVEL:      * 
* Severe                                                       * 
* PID    : 28180562            TID  : 1838        PROC :       * 
* db2sysc                                                      * 
* INSTANCE: dbuser              NODE : 000        DB  : WSDB   * 
* APPHDL  : 0-49                APPID:                         * 
* *LOCAL.dbuser.110517162100                                   * 
* AUTHID  : DBUSER                                             * 
* EDUID  : 1838                EDUNAME: db2agent (WSDB)        * 
* FUNCTION: DB2 UDB, index manager, sqlisplt, probe:600        * 
* MESSAGE : Split failed to make room!                         * 
* DATA #1 : Hexdump, 4 bytes                                   * 
* 0x070000000E3F5A78 : 0000 0004 ....                          * 
*                                                              * 
* 2011-05-17-12.22.23.342299-240 I24406A515        LEVEL:      * 
* Severe                                                       * 
* PID    : 28180562            TID  : 1838        PROC :       * 
* db2sysc                                                      * 
* INSTANCE: dbuser              NODE : 000        DB  : WSDB   * 
* APPHDL  : 0-49                APPID:                         * 
* *LOCAL.dbuser.110517162100                                   * 
* AUTHID  : DBUSER                                             * 
* EDUID  : 1838                EDUNAME: db2agent (WSDB)        * 
* FUNCTION: DB2 UDB, index manager, sqlisplt, probe:1300       * 
* RETCODE : ZRC=0x87090054=-2029453228=SQLI_PRG_ERR "Program   * 
* error" DIA8575C An index manager programming error occurred. * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 9.7.0.5.                                      * 
****************************************************************
Local-Fix:
Drop and recreate the affected index without the PAGE SPLIT 
HIGH/LOW clause. 
 
Or alternatively use the ALTER INDEX command with the COMPRESS 
NO, following by using the REORG INDEXES command to recreate the 
problem index as uncompressed. 
 
Or alternatively run "db2set DB2_INDEX_COMPRESSION=OFF" followed 
by db2stop/db2start to pick up this change, then drop and 
recreate the indexes.
verfügbare FixPacks:
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 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

Lösung
The problem is first fixed in DB2 9.7.0.5.
Workaround
Drop and recreate the affected index without the PAGE SPLIT 
HIGH/LOW clause. 
 
Or alternatively use the ALTER INDEX command with the COMPRESS 
NO, following by using the REORG INDEXES command to recreate the 
problem index as uncompressed. 
 
Or alternatively run "db2set DB2_INDEX_COMPRESSION=OFF" followed 
by db2stop/db2start to pick up this change, then drop and 
recreate the indexes.
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
17.05.2011
08.12.2011
08.12.2011
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.0.5
Problem behoben lt. FixList in der Version
9.7.0.5 FixList