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

PROCEDURE CALLS REFERENCING A HOST VARIABLE FAILS TO REGENERATE A DROPPED
TYPE

Produkt:
DB2 FOR LUW / DB2FORLUW / A10 - DB2
Problembeschreibung:
After a type has been dropped, the subsequent call of a 
procedure that casts a host variable as the dropped type fails 
to regenerate the type. 
 
For example, in the following scenario, SQL901N instead of the 
proper SQL723N (SQL204N) may be returned. 
 
create table t1 (c1 int, c2 int); 
create type r1 as row (c1 int, c2 int); 
create type r2 as row (c1 int, c2 int); 
create type a2 as r1 array[10]; 
 
create function foo() returns a2 
begin 
 declare lv1 a2;-- 
 return lv1;-- 
end; 
 
create or replace procedure poo() 
begin 
 declare s1 varchar(200);-- 
 set s1 = 'delete from t1 where c1 = cardinality(cast (? as 
a2))';-- 
 prepare st from s1;-- 
 execute st using foo();-- 
end; 
 
drop type r1; 
drop type r2; 
 
-- SQL901N 
call poo(); 
 
Here is the error stack: 
---------------------------------------------------------------- 
---------------- 
--sqlnn_cmpl                [300]:rc(-2144272270) Error in 
parser 
--sqlnp_main                [250]:rc(-2144272270) Invoke LPG 
parser (semantic phase) 
--sqlnp_parser              [330]:rc(-2144272270) Call smactn 
 
--sqlnp_smactn              [100]:rc(-2144272270) Processing 
semantic action 
--sqlnq_sem_host            [245]:rc(-2144272270) convert host 
variable type to dat_TYPTYPE 
--sqlnq_convertHVtoDatTyp   [243]:rc(-2144272209) Could not 
fetch type packed descriptor. 
---------------------------------------------------------------- 
---------------- 
--SQL0901N  The SQL statement failed because of a non-severe 
system error. 
--Subsequent SQL statements can be processed.  (Reason 
"sqlnq_convertHVtoDatTyp 
--[243]:rc(-2144272209) Could not fetch".)  SQLSTATE=58004
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update to DB2 Version 10.1 Fix Pack 3 or later.              * 
****************************************************************
Local-Fix:
Calling a procedure that depends on a type that has been dropped 
will result in an error SQL723N (SQL204N) anyway.  Users should 
either drop the procedure or recreate the missing type. 
 
If the type is recreated, before calling the user procedure, 
call the following admin procedure to manually regenerate the 
type: 
    call admin_revalidate_db_objects('type', NULL, NULL);
Lösung
The problem was first fixed in DB2 Version 10.1 Fix Pack 3.
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
28.11.2012
21.10.2013
21.10.2013
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version