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

SQL20481N ERROR CAN BE RETURNED WHEN STORED PROCEDURE MODIFIES TABLE WITH
INLINED TRIGGER DEFINED

Produkt:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problembeschreibung:
There are two types of recursive dependencies that can be 
created and result in SQL20481N error 
 
A) reflexive dependency when SP depends on itself can be created 
when following characteristics exist 
1. SP1 modifies base table T1 
2. T1  has a trigger TRIG1 defined on it 
3. TRIG1 calls SP1 
 
and actions are performed 
 
1. drop SP1  once trigger has been created 
2. use 'create or replace' syntax to re-create the procedure 
 
At this point there is a reflexive dependency in catalogs of SP1 
-> SP1 and using 'create or replace ' syntax to recreate SP1 
will result in SQL20481N error 
 
B) Indirect recursive dependency where SP depends on other 
object and this object depends on SP can occur when SP's exhibit 
following characteristics 
 
1. SP1 modifies base table 
2. SP2 uses base table and calls SP1 
3. Trig calls SP2 
 
and following actions take place 
 
1. SP1 is dropped 
2. SP1 is created using 'create or replace' syntax 
3. alter on base table is performed to invalidate SP1 & SP2 
4. Call SP1 to trigger automatic revalidation 
 
This will result in SP1 -> SP2 -> SP1 indirect recursive 
dependency in catalogs and any subsequent attempts to use 
'create or replace' syntax to recreate SP1 or SP2 will fail with 
SQL20481N error
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 10.5 FP 7                             * 
****************************************************************
Local-Fix:
It is necessary to drop SP's and recreate them
Lösung
First fixed in DB2 Version 10.5 FP 7
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
30.06.2014
27.01.2016
27.01.2016
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.5.0.7 FixList