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 | |
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 |