DB2 - Problembeschreibung
Problem IC78631 | Status: Geschlossen |
DB2 SQL QUERY OPTIMIZER HAS IMPROVED THE PERFORMANCE OF THE JOIN OPERATION FOR FOREIGN KEY CONSTRAINT ENFORCEMENT IN DPF | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
DB2 SQL Query Optimizer has improved the performance of the join operation for foreign key constraint enforcement when all of the following conditions are satisfied: (1) It is a partitioned (DPF) environment (2) There exists tables P (parent) and C (child) where P is the parent table of C in a foreign key constraint. P and C could be the same table (i.e. self-referencing foreign key constraint). (3) the SQL statement being compiled contains an INSERT/UPDATE operation (e.g. INSERT statement, UPDATE statement, INSERT or UPDATE operation in a MERGE statement) on table C, which requires a scan on table P to check for the existence of parent key. (4) P is also updated in the SQL statement prior to the INSERT/UPDATE operation mentioned in (3) above. Example: (assuming table P is a parent of table C in a foreign key constraint in DPF) begin atomic insert into P values (1,1);-- update C set i2 = i2 + 1;-- end; | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * DPF customers. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 9.7 Fixpack 6 or later. * **************************************************************** | |
Local-Fix: | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows | |
Lösung | |
The issue is first fixed in DB2 Version 9.7 Fixpack 6. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC84219 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 13.09.2011 12.06.2012 12.06.2012 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP6 | |
Problem behoben lt. FixList in der Version | |
9.7.0.6 |