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 | |
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 |