Fixes are available
DB2 Version 9.5 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
Closed as program error.
create table archive (activity varchar(100), description varchar(100)) options ( REMOTE_SERVER 'UDBSERVER', REMOTE_SCHEMA 'IIDEV2' ); create table t_activities (activity varchar(100), description varchar(100)) ; --Following query should be blocked during semantics check, otherwise it can consequently cause error or crash, since Federation does not support nickname or query over nickname as target table of MERGE. MERGE INTO (select * from archive where archive.activity like '123' ) as ar USING (SELECT activity, description FROM t_activities) ac ON (ar.activity = ac.activity) WHEN MATCHED THEN UPDATE SET (activity, description) = (ac.activity, ac.description) WHEN NOT MATCHED THEN INSERT (activity, description) VALUES (ac.activity, ac.description) ; Here are the condition where a query may hit this problem: 1) There must be a MERGE statement, which takes a query involving nickname as its target table
Not to use MERGE with query of nickname as the target table
Users affected: Users of the DB2 for LUW Homogeneous Federation Feature or InfoSphere Federation Server Problem description and summary: See error description.
Problem was first fixed in Version 9.5 FixPak 5 (s091123 ). This fix should be applied on the federation server.
Reported component name
Reported component ID
Last modified date
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fixed component name
Fixed component ID
Applicable component levels
22 December 2009