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

Memory & performance impact when differing length values repeate dly
assigned to same slot of array of variable length datatype

Produkt:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problembeschreibung:
When using array of variable length data type in a SQL Stored 
Procedure and assigning different length element to the same 
slot many times you may see memory consumption grow and 
performance worsen. This can happen with both local variables 
and with global variables, but is more common with global 
variables. 
 
Here is some sample code that can be used to demonstrate the 
problem 
 
create package M1 
as 
  TYPE GCHAR IS TABLE OF VARCHAR2(30) INDEX BY VARCHAR2(30); 
  G_CHAR GCHAR; 
end; 
 
create procedure P1(X in number) 
as 
  i number; 
begin 
  FOR I IN 1..X 
  LOOP 
      M1.G_CHAR('1') := NULL; 
      M1.G_CHAR('2') := NULL; 
      M1.G_CHAR('3') := NULL; 
      M1.G_CHAR('4') := NULL; 
      M1.G_CHAR('1') := cast(i as varchar2(30)); 
  END LOOP; 
end; 
 
If you then call this sample procedure 
 
call P1(3000); 
 
declare 
  V varchar2(30); 
begin 
  V := M1.G_CHAR('1'); 
  dbms_output.put_line(V); 
end; 
 
call P1(3000); 
 
The second call will be significantly slower.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All users of DB2 LUW                                         * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 10.5 FP7                                      * 
****************************************************************
Local-Fix:
Lösung
Problem first fixed in DB2 10.5 FP7
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
20.07.2015
28.01.2016
28.01.2016
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.5.0.7 FixList