|
Problem IC78680
|
Status: Geschlossen |
DB2 SERVER MIGHT TRAP DURING QUERY COMPILE WHEN FREQUENT VALUE STATS UPDATED WITH NULL ENTRY |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 950 - 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: *
* 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 *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Version 9.5 FixPack 9 *
**************************************************************** |
| Local-Fix: |
The problem can be avoided by not modifying the frequent value
statistics with a null entry |
| verfügbare FixPacks: |
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
|
| Lösung |
First Fixed in Version 9.5 FixPack 9 |
| Workaround |
The problem can be avoided by not modifying the frequent value
statistics with a null entry |
| Kommentar |
999 |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 14.09.2011
23.03.2012
23.03.2012 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.5.FP9
|
| Problem behoben lt. FixList in der Version |
| 9.5.0.9
|
 |
