Refer to this table when you want to know whether or not a data source supports a specific federated feature.
Before you can use some of these features, you may need to set specific wrapper or server options or perform other tasks to enable the functionality. For more information, see the specific topics on each feature.
| Feature | Data sources |
|---|---|
| Application savepoints with WRITE operations against nicknames | DB2 for Linux, UNIX, and Windows |
| Asynchrony optimization | All data sources |
| Cache tables | DB2 family |
| Data import into nicknames | DB2 family |
| Error tolerance in nested table expressions | DB2 family |
| External user mapping repository | All data sources |
| Federated health indicators | DB2 family |
| Federated procedures | DB2 family, in trusted mode |
| Federated trusted contexts | DB2 for Linux, UNIX, and Windows Version 9.5 |
| HTTP proxy | Web services |
| Connection-level isolation | DB2 family |
| Label-based access control | DB2 for Linux, UNIX, and Windows Version 9.1 |
| LOB read and write operations | DB2 for z/OS |
| LOB read-only operations | BioRS |
| Materialized query tables | All data sources, with specific restrictions |
| Nickname statistics update facility | BioRS |
| Pass-through sessions | DRDA |
| Remote XML data type | DB2 for Linux, UNIX, and Windows |
| SOCKS proxy | BioRS Note: To connect to relational
data sources, you must set DB2ENVLIST=SOCKS5C_CONFIG.
|
| Secure Socket Layer (SSL) | Web services |
| Statement-level isolation | DB2 family |
| Two-phase commit transactions | DB2 for Linux, UNIX, and Windows, in trusted mode |
| Unicode support | All data sources |