|
Problem IC78680
|
Status: Closed |
DB2 SERVER MIGHT TRAP DURING QUERY COMPILE WHEN FREQUENT VALUE STATS UPDATED WITH NULL ENTRY |
| product: |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 |
| 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 |
| Problem Summary: |
****************************************************************
* 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 |
| available fix packs: |
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
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 |
| Comment |
999 |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 14.09.2011
23.03.2012
23.03.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.5.FP9
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.5.0.9
|
 |
