Articles & Content


Federation - Join your forces in the InfoSphere (G01)

Topic: 2011 NA

Subtopic: DB2 for LUW

DATE: 2011-5-3 (12:45 PM - 01:45 PM)
SPEAKERS: Peter Suhner (AXA Tech Switzerland)

Ever wanted to quickly make your DB2 data available to an MS SQL database? Or how about an SQL join of your DB2 with Oracle tables? DB2 Federation (or InfoSphere Federation Server) allows you to interconnect a variety of relational and non-relational data sources. Furthermore, Federation is the foundation technology for DB2 Heterogeneous Replication.The presentation provides an overview of the Federation feature in a heterogeneous world.Information Integration between DB2 LUW, DB2 z/OS, Oracle and MS SQL is covered in practical examples.Starting with an overview of the architecture and components, it will lead through the objects and definitions that are required to make heterogeneous federation work smoothly. Practical considerations are added to complete the picture.

EXP. LEVEL: Beginner,Intermediate,Advanced


Get a quick overview of InfoSphere/DB2 Federation

Know the elements and objects involved in Federation

See the requirements and steps for a setup covering DB2 z/OS, Oracle and MS SQL Server from DB2 LUW on Unix

Know basic performance considerations

Know where to find additional information

Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.