DB2 FOR LUW / DB2FORLUW / 970 - DB2

The database may abend if the following conditions are 
satisfied: 
 
1. There are two or more tables in the query 
2. There exists more than one primary key (PK) or unique key 
(UK) constraints on one table. 
3. The other table has a referential integrity (RI) constraint 
with only one of the PK/UK. 
4. The remaining PK/UK column(s) are not referenced in the 
SELECT list. 
 
Following stack will be observed: 
 
sqlnr_rijel_action 
sqlnr_comp 
sqlnr_seq 
sqlnr_rcc 
sqlnr_endqtb_action 
sqlnr_comp 
sqlnr_seq 
sqlnr_rcc 
sqlnr_start_action 
sqlnr_comp 
sqlnr_seq 
sqlnr_rcc 
sqlnr_exe

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* DB2 MAY ABEND WHILE COMPILING A QUERY WITH MORE THAN ONE     * 
* REFERENTIAL INTEGRITY CONSTRAINTS                            * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 Fix Pack 5.                       * 
****************************************************************

N/A

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
 

First fixed in DB2 Version 9.7 Fix Pack 5.

N/A

N/A

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

31.01.2011
07.12.2011
07.12.2011

9.7.FP5