Federation server enhancements
Db2 11.5.6 provides enhanced access to data sources in a Federation Server environment.
| Enhancement | Description |
|---|---|
| Bulk insert support for Db2 data sources through Db2 DRDA wrapper. | With the release of Db2 11.5.6, you can insert a set of records into Db2 in a single insert operation, gaining performance benefit against one record per one insert operation. |
| Support for Apache Spark SQL data sources through a Federation JDBC connection | With the release of Db2 11.5.6, you can connect to an Apache Spark data source using the Federation JDBC wrapper. |
| Nickname hidden columns | With the release of Db2 11.5.6, you can now query nickname hidden columns. |
| Extended nickname column for full result set when code set incompatibility exists | With the release of Db2 11.5.6, you can now use the extended nickname feature to automatically increase the length of a column and receive the entire result set from the remote server. This feature addresses the issue of differences in code point size, between the federated database and the remote data source, affecting the result set. For more information, see Extended nickname column when the code set is incompatible. |