IBM® InfoSphere® Federation Server introduces new functionality in Version 10.1 and changes to existing functionality from Version 9.7.
The key features of this release include improved usability, enhanced Netezza support, and integration with DB2® pureScale® and other DB2 Database for Linux, UNIX, and Windows features. For a list of the new features provided with the DB2 server, refer to the What's New overview.
The ODBC wrapper transparently recognizes and optimizes access to Netezza data sources. No wrapper or server options are required to benefit from this enhancement. For more information, see ../../com.ibm.swg.im.iis.found.conn.fw.odb.doc/topics/iiynwodb_netzaddt.html.
Federated three-part names provide the ability to reference remote objects directly and eliminates the need to create nicknames. You can use three-part names where you can use nicknames. With enhanced SQL statement syntax, you can reference remote tables by using three-part names that are compatible with the three-part names for Oracle dblinks. If you are migrating an application from Oracle to DB2 or Federation Server, three-part names simplify the process since you do not need to change your dblink syntax. For more information, see ../../com.ibm.swg.im.iis.fed.query.doc/topics/iiyfq3pnintro.html.
The wrapper configuration tool is introduced in version 10.1 to simplify the task of configuring relational wrappers. You can use this tool to set system variables and, for the Informix and Teradata data sources, run the djxlink script. For more information, see ../../com.ibm.swg.im.iis.db.prod.fed.nav.doc/topics/iiyfcfgtool.html.
Dynamic linking of library files is implemented for the Oracle wrapper to simplify client configuration. After installing Federation Server or making a change to the Oracle client, you no longer need to run the djxlink or djxlinkOracle scripts. For more information, see ../../com.ibm.swg.im.iis.db.found.conn.fw.configgen.doc/topics/tlssetsrv04.html.
Federated two-phase commit transactions are enabled in fenced mode for the DRDA and Oracle wrappers. For more information, see ../../com.ibm.swg.im.iis.fed.query.doc/topics/cfptsp01.html.
Management of Teradata LOB data is enhanced with the ability to perform write operations. You can perform inserts and updates on LOB columns and nicknames of Teradata tables. For more information, see ../../com.ibm.swg.im.iis.fed.appdev.doc/topics/cfpprg12.html.
You can now use Federation Server to extend a DB2 pureScale database. This integration enables all data sharing members to process heterogeneous SQL and improves the availability and scalability of federation. For more information see ../../com.ibm.swg.im.iis.db.fed.overview.doc/topics/iiyfointpscale.html.
Federation Server supports temporal tables introduced in DB2 version 10.1. You can create a nickname over a remote temporal table and perform insert, update, and delete operations against the nickname. For more information see ../../com.ibm.swg.im.iis.fed.query.doc/topics/iiyfadmtemporal.html.
Federation Server supports DB2 fine-grained access control introduced in DB2 Version 10.1 for use with the DRDA wrapper. This feature is also referred to as row and column access control. For more information see Row and column access control (RCAC) enhances data security
Statement-level server options help you tune queries and improve query performance. You can set server options for a single SQL statement in an optimization profile to influence the DB2 optimizer. For more information, see ../../com.ibm.swg.im.iis.fed.tuning.doc/topics/iiyftstlevservopt.html.
Nickname statistics are enhanced with a new option for updating catalog statistics to ensure consistent statistic values. For more information, see ../../com.ibm.swg.im.iis.fed.query.doc/topics/rfpsts08.html.
The Federation Server installer for Version 10.1 provides a set of installation programs that simplify the installation of federation components. For more information, see ../../com.ibm.swg.im.iis.db.prod.fed.nav.doc/topics/iiyvfed_installing_l1.html.