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:
- You can federate any combination of DB2, Oracle, and Informix* databases.
- This Oracle federation cannot be used with data replication solutions such as SQL and Q Replication. You need to purchase a license InfoSphere Data Replication or InfoSphere Replication Server to use federation as part of heterogeneous replication.
- If you get the 9.8 pureScale feature for DB2 AESE, you cannot convert a 9.8 pureScale database in to a federated pureScale database. You must buy and use a separate Federation Server and have pureScale be a data source of that Federation Server.
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.