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:
|
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.
|