Federation server enhancements

Db2 11.5.4 provides enhanced access to data sources in a Federation Server environment.

Attention: The enhancements in this topic are included in the Db2 11.5.4 mod pack release, which is available for the following products:

Db2 on-premises
The single container deployments of Db2 Warehouse and IBM Integrated Analytics System (IIAS)
The container micro-service deployment of Db2 on Red Hat OpenShift

Enhancement	Description
Support for various data sources through federation JDBC wrapper	Optimizes federation JDBC wrapper for connecting to various data sources including: Relational data sources: IBM® Db2, Oracle, and Microsoft SQL Server. Warehouse or appliance: IIAS, Netezza®, SAP HANA, and Greenplum. Open source data sources: MySQL, PostgreSQL, MariaDB, and Derby. Hadoop data sources: IBM Db2 BigSQL, and Hive. Mainframe: Db2 for z/OS®, and Rocket Data Virtualization Manager. Cloud-based data sources: Db2 Warehouse, Amazon AWS Redshift, Google BigQuery, Amazon AWS S3, Amazon Athena, and Salesforce.
Support for AutoREST Connector	Enables Autonomous REST Connector which is a JDBC connector for accessing to various JSON-based data sources through RESTful API
Support for JWT (JSON Web Token) for SSO	Logs into a remote data source without providing a userid and password. Experience single sign-on (SSO) with Db2 applications.
Inter-partition parallelism with parallel fetching	Exploits all the applicable partitions to involve in the execution of one Federated SQL statement to accelerate the execution speed which can gain better performance improvement.
Support bulk insert for Oracle through Oracle Net8 wrapper	Inserts a set of records into Oracle in one insert operation, and gain performance benefit against one record per one insert operation.
Federation FMP enhancement - Buffer size optimization	The default size of federation FMP communication buffer has been changed to 2MB. This increases the previous default value of 60KB, which improves federation nickname query performance by optimizing the block fetching buffer size.
Pushdown capability enhancement for MongoDB through NoSQL wrapper	Filters will be pushed down to MongoDB. This will reduce the data transfer.
Enhanced federation pushdown capability on fetch first (n) rows (FFNR) queries against various data sources	Db2 is now able to take the FFNR portion of a SQL query and push it down to the following federated data sources. MySQL Teradata Microsoft SQL Server Netezza Spark Hive Impala Oracle MariaDB SAP HANA PostgreSQL Greenplum This feature reduces data transfer.