DB2 - Problembeschreibung
Problem IC65581 | Status: Geschlossen |
DELETE FROM TABLE MAY RETURN SQL0440N AFTER A COLUMN WAS DROPPED FROM ITS DEPENDENT/PARENT TABLE IN A FOREIGN KEY CONSTRAINT | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 910 - DB2 | |
Problembeschreibung: | |
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. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * All DB2 Version 9.1 GA through Fix Pack 8 servers * * on Linux, Unix and Windows where a column is * * dropped from a table involved in a foreign key * * constraint. * **************************************************************** * PROBLEM DESCRIPTION: * * 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. * **************************************************************** * RECOMMENDATION: * * Update to Version 9.1 Fix Pack 9 * **************************************************************** | |
Local-Fix: | |
Contact IBM Support to have the corrupted descriptor patched. | |
verfügbare FixPacks: | |
DB2 Version 9.1 Fix Pack 9 for Linux, UNIX and Windows | |
Lösung | |
Problem was first fixed in Version 9.1 Fix Pack 9 | |
Workaround | |
See LOCAL FIX | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 14.01.2010 14.04.2010 14.04.2010 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.1.FP9 | |
Problem behoben lt. FixList in der Version | |
9.1.0.9 |