home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

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
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

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 FixList