About Data Federation
DavidT 120000JC6D Tags:  teradata federation_server oracle virtualization db2 warehouse infosphere sybase sql_server federation 2,460 Visits
As more shops start their move to DB2 pureScale, we get asked if federation is supported with pureScale. The answer is yes, Federation Server as well as DB2's and InfoSphere Warehouse's built-in homogeneous federation all support pureScale as a data source. That's because pureScale is really just another DB2 from a federation perspective. In other words, Federation accesses pureScale just as it would any other kind of DB2 - as client application - which means the pureScale nature of the DB2 is transparent.
The following picture is an example of how federation works with pureScale:
Obviously, this is just one way federation could be configured. Federation Server doesn't have to run on a separate system. In fact, it could run on any system in this example. I only show it on a separate system to emphasize the fact that federation is running independetly of pureScale. Another point is that, if you only need to federate DB2 databases, you could use a DB2 or InfoSphere Warehouse as your federation server instead of the InfoSphere Federation Server product. (However, you will need to be at 9.7 FP3 or higher no matter which you use.)
The one thing you cannot do is turn pureScale 9.8 into a federated data sharing group and create nicknames. For example, the following is not possible with pureScale 9.8:
In this picture, federation is conceptually integrated into pureScale in such a way that each member could federate pureScale's data with data from other data sources.
DavidT 120000JC6D Tags:  ims i5os informix warehouse federation zos database classic postgresql iseries oracle db2 teradata purescale vsam virtualization infosphere data_virtualization 3,052 Visits
In October 2010, IBM announced a new edition of DB2 called DB2 Advanced Enterprise Server Edition (AESE). In the same letter, IBM also announced that federation of Oracle databases is included at no additional cost in some products. To be precise, InfoSphere Federation Server is included in DB2 AESE and all editions of InfoSphere Warehouse 9.7 as a way to license and enable federation of Oracle databases. This great news for customers who want to federate their old Oracle databases with DB2 as they migrate to DB2.
You can find confirmation of this in the DB2 AESE license information document. However, there are a few points about this that may not be obvious. I'm including them here to provide a more complete picture from a data federation perspective:
If you have any other database you want to federate - Teradata, PostgreSQL, Microsoft SQL Server, IMS, VSAM, etc - you must purchase InfoSphere Federation Server. 'Classic' data sources such as IMS and VSAM may also require you have InfoSphere Classic Federation Server for z/OS.
* Why is Informix included? In DB2 LUW 9.1, IBM defined homogeneous federation as the ability to federate any combinataion of DB2 LUW, DB2 z/OS, DB2 for iSeries (i5OS), and Informix databases. This homogeneous federation was a paid feature of DB2 LUW 9.1. However, in DB2 9.5, IBM included all homogeneous federation in all editions of DB2.
DavidT 120000JC6D Tags:  infosphere federation replication cdc informix db2 1 Comment 2,531 Visits
The answer is yes for most DB2 editions starting with 9.5 FP3b. Here is an excerpt from the 9.5 DB2 Information Center:
The only DB2 edition missing this federation function today is DB2 Express-C (and I have no idea why it's been omitted). Of course, you may be wondering what 'homogeneous' federation has to do with Informix if we're talking about DB2 editions :) The answer can be found in DB2 9.1's announcement letter. In it, IBM defined homogeneous federation as being federation of it's two relational database families at that time:
In the 9.5 time frame, an IBM annoucement letter said that this function would be integrated into the DB2 editions available at that time. The relevant text from that announcement is:
Notice it says "IBM data servers" and not "DB2 servers." The only catch is that it isn't installed by default. You must go through the DB2 install's custom install path to get it. For example, here's what I see in my 9.7's custom install path:
Great :) That only leaves one question...
What About Using This Federation with SQL Replication?
SQL Replication has been built into DB2 since Version 5 in 1997. Once data federation was added to DB2, the SQL Replication administration tools (currently the Replication Center and the asnclp script processor) were updated to allow replication between DB2 and Informix. Just in case you're wondering, the DB2 license information documents do not restrict this function. For example, see the DB2 ESE 9.7 license information document.
One note about this is that, if you want to capture changes from Informix databases, SQL Replication offers only trigger-based capture mechanisms. If you need to capture changes from Informix, a much better alternative is InfoSphere Change Data Capture's (CDC's) log-based capture for Informix.
DavidT 120000JC6D Tags:  web web_services warehouse db2 federation infosphere database 1,454 Visits
IBM's Federation Server has an interface to web services that lets you federate and query web services using SQL. IBM announcement letter 209-134 shows that this Federation Server capability was included in the following DB2 LUW 9.7 editions at no additional cost:
DB2 Advanced ESE (AESE) also has this capability builds on top of DB2 ESE. However, as per the announcement letter, web services federation is not included in Express-C or Personal Edition.
Good news for you InfoSphere Warehouse fans - IBM announcement letter 209-129 shows this capability is in all InfoSphere Warehouse 9.7 editions.
DavidT 120000JC6D Tags:  cdc db2 q_replication infosphere replication_server database federation change_data_capture replication sql_replication 1 Comment 3,142 Visits
With any data replication technology, you may some day find that you need to replicate to a target database not currently supported by your replication technology. The good new is IBM's data federation technology can provide an easy way to extend your solution. For example, federation has long been used to extend IBM's SQL Replication so that it can replicate to PostgreSQL and other databases. Federation also can provide the same benefit for a number of other replication technologies, including InfoSphere Change Data Capture. I'm going to use this post to talk about considerations from a federation perspective. However, I'm not going to into details from a CDC perspective. I recommend you talk to a CDC expert for that. For example, if you have a specific question, the developerWorks CDC message board may be the right place.
It's a short list, but, if I find more later, I'll add them.
If you have questions, you can ask them in the comment section of this blog or use the message boards here on developerWorks.