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 IC88927 Status: Geschlossen

SQLI_SMP_ERR ERROR DURING ROLLBACK OF FREE PAGE OPERATION ON AN INDEX

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
During rollback of a free page operation DB2 may fail with error 
'SQLI_SMP_ERR' due to unexpectedly finding the page marked as 
used. 
 
The db2diag.log will show following severe error: 
 
2012-11-19-13.41.36.051203+060 I34708856A523      LEVEL: Severe 
PID     : 16515112             TID  : 21817       PROC : db2sysc 
0 
INSTANCE: TESTINST             NODE : 000         DB   : TESTDB 
APPHDL  : 0-38753              APPID: 
53.48.16.60.50795.121119123056 
AUTHID  : DB2ADMIN 
EDUID   : 21817                EDUNAME: db2agent (TESTDB) 0 
FUNCTION: DB2 UDB, index manager, sqliundo, probe:2310 
RETCODE : ZRC=0x87090052=-2029453230=SQLI_SMP_ERR "SMP problems" 
          DIA8573C An invalid space map page was found. 
 
The transaction being rolled back must have performed the 
following in this order: 
- updates or deletes that triggered a page merge or page 
deletion in the index and that were performed with exclusive 
access to the table 
- runstats 
- rollback 
 
The table must have 1 or more indexes that were created when the 
table was empty (or that were rebuilt when the table was empty). 
At least one of the indexes must have had less than 25 distinct 
key values for the life of the index.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description.                                       * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 Fix Pack 8.                       * 
****************************************************************
Local-Fix:
Use db2dart /MI to mark affected indexes bad and have them 
rebuilt upon database restart or first access (based on INDEXREC 
configuration).
verfügbare FixPacks:
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
First fixed in DB2 Version 9.7 Fix Pack 8.
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC89032 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
07.12.2012
08.04.2013
08.04.2013
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP8
Problem behoben lt. FixList in der Version
9.7.0.8 FixList