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

INCONSISTENT RUNTIME FOR QUERY ON COLUMN ORGANIZED TABLES

Produkt:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problembeschreibung:
For certain type of queries against column organized tables, 
they may run slower than usual in a heavy workload environment. 
Monitoring with table function mon_bp_utilization shows 
index_phsical_read is happening every time the query is 
executed. The index pages loaded in Bufferpool got victimized 
too quickly and DB2 need to retrieve the data constantly for 
these queries and therefore result in long execution time.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to 10.5 FixPack 6                                    * 
****************************************************************
Local-Fix:
Lösung
First fixed in DB2 V10.5 FixPack 6
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
14.01.2015
23.10.2015
23.10.2015
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.5.0.6 FixList