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

DB2 MAY INSERT A RANDOM NUMBER OF ROWS UNDER VERY SPECIFIC CONDITIONS

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
DB2 may insert a random number of rows when all of the 
following conditions are met: 
 
(1) An INSERT statement of the following form is executed in a 
DPF environment: 
         INSERT INTO <destination> SELECT FROM <nickname_source> 
 
(2) <destination> is a local permanent table or global temporary 
table and resides in a tablespace that spans multiple partitions 
(its containers are on multiple partitions).  If the tablespace 
does not span multiple partitions then the problem does not 
occur. 
 
(3) One or more of the partitioning key columns of <destination> 
are generated by a non-deterministic function (for example, 
SEQUENCE) in the SELECT list. 
 
(4) <nickname_source> is a nickname for a data source object.
Problem-Zusammenfassung:
Users Affected: All 
 
ERROR DESCRIPTION: 
 
  DB2 may insert a random number of rows when all of the 
following conditions are met: 
 
(1) An INSERT statement of the following form is executed in a 
DPF environment: 
         INSERT INTO <destination> SELECT FROM <nickname_source> 
 
(2) <destination> is a local permanent table or global temporary 
table and resides in a tablespace that spans multiple partitions 
(its containers are on multiple partitions).  If the tablespace 
does not span multiple partitions then the problem does not 
occur. 
 
(3) One or more of the partitioning key columns of <destination> 
are generated by a non-deterministic function (for example, 
SEQUENCE) in the SELECT list. 
 
(4) <nickname_source> is a nickname for a data source object. 
 
LOCAL FIX: 
 Choose a partitioning key column that is not generated by a 
non-deterministic function.
Local-Fix:
Choose a partitioning key column that is not generated by a 
non-deterministic function.
verfügbare FixPacks:
DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 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 10 for Linux, UNIX, and Windows

Lösung
First fixed in v97 fp1
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
22.09.2009
17.12.2009
17.12.2009
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP1
Problem behoben lt. FixList in der Version
9.7.0.1 FixList