Fixes are available
APAR status
Closed as program error.
Error description
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
Local fix
Not to use MERGE with query of nickname as the target table
Problem summary
Users affected: Users of the DB2 for LUW Homogeneous Federation Feature or InfoSphere Federation Server Problem description and summary: See error description.
Problem conclusion
Problem was first fixed in Version 9.1 FixPak 8 (s090823). This fix should be applied on the federation server.
Temporary fix
Comments
APAR Information
APAR number
JR31879
Reported component name
FEDERATED RUNTI
Reported component ID
5724N9703
Reported release
910
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2009-02-02
Closed date
2009-10-07
Last modified date
2009-10-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
FEDERATED RUNTI
Fixed component ID
5724N9703
Applicable component levels
R910 PSN
UP
R911 PSN
UP
[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCAVPX","label":"Federated Server"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.1","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
07 October 2009