DB2 FOR LUW / DB2FORLUW / 970 - DB2

Queries with a Union All view of tables from remote data sources 
(data from federated servers) may cause memory overwritten.  The 
problem may happen when all of the following conditions are met 
 
1. The database manager configuration parameter 'FEDERATED' is 
set to 'YES'. 
2. Running a query with a Union All view of tables from the 
federated servers, referred to as UAV. 
3. The query has a IN or EXISTS subquery with view UAV as the 
parent table of the subquery. 
4. The view UAV has a column referencing to constants of 
CHARACTER type. 
5. The constants of CHARACTER type in 4) has different length 
6. Each table from the federated servers has a unique index 
 
A typical use of the constants is to use different values to 
identify the tables under the Union All view. 
 
For example, 
 
The Union All view is defined as: 
CREATE VIEW UAV AS 
SELECT 'BR' AS TABNAME, T.* FROM FED_TABLE1 
UNION ALL 
SELECT 'BR1' AS TABNAME, T.* FROM FED_TABLE2; 
 
Both table FED_TABLE1 AND table FED_TABLE2 have unique indexes 
defined in the remote servers where the data of the table 
physically located. 
 
Assume TABLE_REF is a table. 
 
The query 
 
SELECT UAV.* 
FROM  UAV 
WHERE UAV.TABNAME IN (SELECT TABNAME FROM TABLE_REF); 
 
may cause memory overwritten.

QUERIES WITH A UNION ALL VIEW OF TABLES FROM FEDERATED SERVERS 
MAY CAUSE MEMORY OVERWRITTEN

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
 

First fixed in DB2 UDB Version 9.7, FixPak 1

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

01.09.2009
28.12.2009
28.12.2009

9.7.