External table enhancements
Db2 11.5.9 extends remote storage access to include External Tables.
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
The following table displays a list of External table enhancements in Db2
11.5.9:
| Enhancement | Description |
|---|---|
| Remote storage alias feature now available to Db2 External Tables | DB2REMOTE identifiers are used to access objects on remote storage. With the
release of Db2
11.5.9,
you can now use remote storage aliases specified in DB2REMOTE identifiers when establishing
connections to External Tables. By using an alias, the need to provide credentials such as vendor,
server/endpoint, and authkey1/username is removed, as these values are retrieved from the alias.
This hiding of credentials improves the security of the connection. For more information, see Creating a remote storage alias for accessing external tables |