|
Problem IC78641
|
Status: Closed |
DB2 SERVER MIGHT TRAP DURING QUERY COMPILE WHEN FREQUENT VALUE STATS UPDATED WITH NULL ENTRY |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - 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: *
* 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 |
| available fix packs: |
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
|
| Solution |
First Fixed in DB2 Version 9.7 FixPack 5 |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC78680
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 13.09.2011
08.12.2011
08.12.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.,
9.7.FP5
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.5
|
 |
