DB2 FOR LUW / DB2FORLUW / 980 - DB2

This problem may affect either the parent or the dependent table 
in a foreign key constraint, depending on the table against 
which the DROP COLUMN was issued. 
 
Dropping a column from a table involved in a foreign key 
constraint may cause incorrect updates to the referential 
constraint descriptor of the "partner" table. As a result, a 
DELETE FROM against the "partner" table may return SQL0440N due 
to a column type mismatch caused by the corrupted descriptor. 
The following error message is returned: 
 
SQL0440N  No authorized routine named "=" of type "FUNCTION" 
having compatible arguments was found.  SQLSTATE=42884 
 
One condition that may lead to this problem is when column(s) 
with higher column id value comes before column(s) with lower 
column id value in the foreign key definition. 
 
e.g. db2 "alter table t2 add constraint fk foreign key (c3, c1, 
c2) references t1 (c3, c1, c2)" where c1 represent column with 
column id 1.

**************************************************************** 
* USERS AFFECTED:                                              * 
* All DB2 Version 9.8 GA through Fix Pack 2 servers on         * 
* Linux,Unix and Windows where a column is dropped from a      * 
* tableinvolved in a foreign key constraint.                   * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* Dropping a column from a table involved in a foreign         * 
* keyconstraint may cause incorrect updates to the             * 
* referentialconstraint descriptor of the "partner" table. As  * 
* a result, aDELETE FROM against the "partner" table may       * 
* returnSQL0440Ndue to a column type mismatch caused by        * 
* thecorrupted descriptor.                                     * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update to Version 9.8 Fix Pack 3                             * 
****************************************************************

Contact IBM Support to have the corrupted descriptor patched.

DB2 Version 9.8 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 9.8 Fix Pack 4 for AIX and Linux
 DB2 Version 9.8 Fix Pack 5 for AIX and Linux
 

Problem was first fixed in Version 9.8 Fix Pack 3

not known / see Local fix

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

18.02.2010
10.01.2011
10.01.2011

9.8.FP3