Federation server enhancements
Db2 11.5.9 provides enhanced access to data sources in a federation server environment.
Attention: This mod pack release is currently available for
the following Db2® products:
- Db2 Distributed (on-premises)
- The single container deployment of Db2 Warehouse.
- The container micro-service deployment of Db2 on Red Hat OpenShift, the Amazon Elastic Kubernetes Service (EKS), the Red Hat OpenShift Service on AWS (ROSA), and the Azure Kubernetes Service (AKS).
- Db2 for cloud service providers
- Db2 on Cloud
- Db2 Warehouse on Cloud
| Enhancement | Description |
|---|---|
| Federation IBM watsonx.data support | Federation now supports IBM watsonx.data as a data source for establishing connections, data type mapping, function push-down, and server attributes optimization. This enhancement improves query performance. |
| Federation Amazon Aurora PostgreSQL support | Federation now supports Amazon Aurora PostgreSQL for establishing connections, data type mapping, and function push-down. |
| Federation supports for PostgreSQL 12, 13, 14 and 15. | Federation now supports PostgreSQL 12, 13, v14 and v15 as data sources through the use of ODBC and JDBC wrappers. These PostgreSQL data source can be used for establishing connections, data type mapping, and function push-down. |
| Timestamp filter predicate push-down for MongoDB | Federation now supports the timestamp filter predicate for push-down to MongoDB |