Latest versionsfixlist
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
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

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 FixList
This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.