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

DB2 SERVER MIGHT TRAP DURING QUERY COMPILE WHEN FREQUENT VALUE STATS
UPDATED WITH NULL ENTRY

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
This problem can occur during query compilation of an SQL 
statement that contains one or more equality join predicates, 
one or both of the columns in the join predicate have 
distribution statistics collected, and one or more frequent 
value statistics have been updated manually with a null entry in 
the system catalog. 
 
You can identify that you hit this problem if the following 
function list is found in the trap file stack trace: 
 
 sqlrxcp2 
 sqlno_compare_literal 
 sqlno_nud_compare_literal 
 sqlno_nud_compare_literal 
 sqlno_ff_updateEffHighLowKeys 
 sqlno_prd_flag_join_type 
 sqlno_ff_prd_info 
 sqlno_ff_col_eq_col 
 sqlno_ff_compute_atomprd
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* Please see problem description above.                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Uprade  DB2 Version 9.7 FixPack 5.                           * 
****************************************************************
Local-Fix:
The problem can be avoided by not modifying the frequent value 
statistics with a null entry
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
First Fixed in DB2 Version 9.7  FixPack 5
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC78680 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
13.09.2011
08.12.2011
08.12.2011
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.,
9.7.FP5
Problem behoben lt. FixList in der Version
9.7.0.5 FixList