Fixes are available
APAR status
Closed as program error.
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.
Problem summary
DB2 MAY INSERT A RANDOM NUMBER OF ROWS UNDER VERY SPECIFIC CONDITIONS
Problem conclusion
First Fixed in V9.1 FP8
Temporary fix
N/A
Comments
APAR Information
APAR number
IZ45674
Reported component name
DB2 EDE AIX
Reported component ID
5724N7600
Reported release
910
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2009-03-11
Closed date
2009-10-09
Last modified date
2009-10-09
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
DB2 EDE AIX
Fixed component ID
5724N7600
Applicable component levels
R910 PSY
UP
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"910","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
09 October 2009