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 IC89750 Status: Geschlossen

SQL20253N RETURNED WHEN MULTIPLE UPDATES ON THE SAME COLUMN FOR COMPILED
TRIGGERS

Produkt:
DB2 FOR LUW / DB2FORLUW / A10 - DB2
Problembeschreibung:
If a compiled trigger is fired multiple times due to the 
multiple foreign key constraints and attempts to update the same 
column, the update will be blocked with SQL20253N error. 
 
e.g. 
 
create table p1(p1_id int not null primary key)@ 
 
create table c1(c1_id int not null primary key, p1_id int)@ 
 
create table c2 (c2_id int not null primary key, p1_id int, 
c1_id int, val varchar(10))@ 
 
alter table c1 add constraint c1_fk1 foreign key (p1_id) 
references p1 (p1_id) on delete cascade on update no action@ 
 
alter table c2 add constraint c2_fk1 foreign key (p1_id) 
references p1 (p1_id) on delete set null on update no action@ 
 
alter table c2 add constraint c2_fk2 foreign key (c1_id) 
references c1 (c1_id) on delete set null on update no action@ 
 
create trigger t1 before update on c2 referencing new as n for 
each row begin set n.val = val + 1; end@ 
 
 
Upon deletion from p1 both c2_fk1 and c2_fk2 constraints are 
triggered which causes trigger t1 to fire twice, attempting to 
update c2.val column each time (which is blocked in existing 
behavior) 
 
This APAR fix modifies the current behavior to allow for 
multiple updates of the same column for compiled triggers, and 
the compiled trigger will execute successfully. 
 
However, this behavior will still be blocked for inline triggers 
at DDL time.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update to v10.1 Fix Pack 3                                   * 
****************************************************************
Local-Fix:
verfügbare FixPacks:
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows

Lösung
Problem first fixed in v10.1 Fix Pack 3
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
22.01.2013
01.10.2013
01.10.2013
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.1.0.3 FixList
10.1.0.3 FixList