Data source support for federated features
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 |
|---|---|
| Automatic client reroute (ACR) | None |
| Application savepoints with WRITE operations against nicknames |
BigInsights
IBM® Db2® on Cloud Db2 |
| Asynchrony optimization | All data sources |
| Cache tables | BigInsights
IBM Db2 on Cloud Db2 family Informix Microsoft SQL Server Oracle Sybase |
| Data import into nicknames | BigInsights
IBM Db2 on Cloud Db2 family Informix Microsoft SQL Server Oracle Sybase Teradata |
| Error tolerance in nested table expressions | BigInsights
IBM Db2 on Cloud Db2 family Informix JDBC Microsoft SQL Server ODBC Oracle Sybase Teradata |
| External user mapping repository | All data sources
|
| Federated health indicators | BigInsights
IBM Db2 on Cloud Db2 family Excel Informix JDBC Microsoft SQL Server ODBC Oracle Sybase Table-structured files Teradata XML (root nicknames only) |
| Federated procedures | BigInsights
IBM Db2 on Cloud Db2 family, in trusted mode Oracle, in trusted mode Microsoft SQL Server, in trusted mode Sybase, in fenced mode, with the federated server installed on UNIX Sybase, in fenced mode or trusted mode, with the federated server installed on Linux® or Microsoft Windows |
| Federated trusted contexts | BigInsights
IBM Db2 on Cloud Db2 Version 9.5 Db2 for z/OS® Version 9 Oracle |
| HTTP proxy | Web services
XML |
| Connection-level isolation | BigInsights
IBM Db2 on Cloud Db2 family Informix JDBC Microsoft SQL Server ODBC Oracle Sybase |
| Label-based access control | BigInsights
IBM Db2 on Cloud Db2 Version 9.1 and 9.5 Oracle |
| LOB read and write operations | BigInsights
IBM Db2 on Cloud Db2 for z/OS Db2 Db2 for IBM i Oracle Teradata |
| LOB read-only operations | BioRS
Informix JDBC Microsoft SQL Server ODBC Script Sybase Web services XML |
| Materialized query tables | All data sources, with specific restrictions
|
| Nickname statistics update facility | BigInsights
BioRS IBM Db2 on Cloud Db2 family Excel Informix JDBC Microsoft SQL Server ODBC Oracle Sybase Table-structured files Teradata XML (root nicknames only) |
| Pass-through sessions | DRDA
Informix Oracle Microsoft SQL Server Sybase Teradata |
| Remote XML data type | BigInsights
IBM Db2 on Cloud Db2 XML wrapper |
| SOCKS proxy | BioRS
Script Web services XML All relational data sources Note: To connect to relational
data sources, you must set
DB2ENVLIST=SOCKS5C_CONFIG. |
| Secure Socket Layer (SSL) | Web services
XML |
| Statement-level isolation | BigInsights
IBM Db2 on Cloud Db2 family Microsoft SQL Server |
| Two-phase commit transactions | BigInsights
IBM Db2 on Cloud Db2, in trusted mode Db2 for IBM i, in trusted mode Db2 for z/OS, in trusted mode Informix, in trusted mode Microsoft SQL Server, in trusted mode, with the federated server installed on Microsoft Windows Oracle, in trusted mode Sybase, in trusted mode, with the federated server installed on Microsoft Windows Sybase, in fenced mode, with the federated server installed on UNIX |
| Unicode support | All data sources
|
| Work load balancing (WLB) | Db2 for z/OS |