DB2 FOR LUW / DB2FORLUW / 970 - DB2

DB2 may abend in sqlng_build_SQLD_VALS_obj during SQL statement 
compilation with the stack similar to following: 
 
sqlng_build_SQLD_VALS_obj 
sqlng_build_TA_op 
sqlng_process_f_ioa 
sqlng_process_fetch_op 
sqlng_process_sort_op 
sqlng_build_thread 
..... 
 
The following conditions must be satisfied for the trap to occur 
 
 
1. There exists optimizer MQT to which the query may be routed. 
An optimizer MQT is Materialized Query Table whose definition is 
plainly a SELECT statement from one base table or multiple base 
table joined together. 
2. The query has equality join predicate Tab1.ColX = Tab2.ColY. 
The two columns are defined in different column types, e.g. one 
is CHAR(10) the other is VARCHAR(10). 
3. The query has IN predicate Tab1.ColX IN (<liberal1>, 
<literal2>, ..., <liberalN>). The IN element list consists of 
literals. 
4. The SELECT clause of MQT definition query contains exactly 
one column out of Tab1.ColX and Tab2.ColY.

**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 9.7 Fixpak 7                                  * 
****************************************************************

Make both join columns present in MQT SELECT list. For example, 
if MQT definition is "SELECT Tab1.ColX...", change it to "SELECT 
Tab1.ColX, Tab2.ColY...".

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
 

First fixed in DB2 9.7 Fixpak 7

not known / see Local fix

forerunner  : APAR is sysrouted TO one or more of the following: IC87851 
follow-up : 

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

27.02.2012
13.11.2012
13.11.2012

9.7.