|
Problem IC63300
|
Status: Closed |
DB2 MAY INSERT A RANDOM NUMBER OF ROWS UNDER VERY SPECIFIC CONDITIONS |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem 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. |
| Problem Summary: |
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. |
| available fix packs: |
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
|
| Solution |
First fixed in v97 fp1 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 22.09.2009
17.12.2009
17.12.2009 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP1
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.1
|
 |
