Fixes are available
APAR status
Closed as program error.
Error description
If you are using the partitioned database environment and your query satisfies the following conditions, then the results returned might be incorrect 1. there is a table, T1, that is hash distributed across two or more database partitions; 2. T1 is correlated to multiple branches below a UNION; 3. each branch of the UNION is correlated to at least one different column in T1; 4. one of the branches is correlated to the hash distribution key of T1; 5. the columns in the select list of each UNION branch includes the correlation column. The following is an example of a query that satisfies the above conditions, where T1 is hash distributed on column X: SELECT * FROM T1, TABLE(SELECT X FROM T2 WHERE X = T1.X UNION ALL SELECT Y FROM T3 WHERE Y = T1.Y);
Local fix
You can avoid the problem by rewriting the query to remove the correlation below the UNION.
Problem summary
**************************************************************** * USERS AFFECTED: * * All users of database partitioning feature. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 version 10.1.0.2. * ****************************************************************
Problem conclusion
The problem is first fixed in DB2 version 10.1.0.2.
Temporary fix
Comments
APAR Information
APAR number
IC85425
Reported component name
DB2 FOR LUW
Reported component ID
DB2FORLUW
Reported release
A10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
YesSpecatt / Pervasive
Submitted date
2012-07-19
Closed date
2012-12-07
Last modified date
2012-12-07
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 FOR LUW
Fixed component ID
DB2FORLUW
Applicable component levels
RA10 PSN
UP
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1"}]
Document Information
Modified date:
19 September 2021