IBM Db2 Database OCF Connector Release Notes

Alation Cloud Service Applies to Alation Cloud Service instances of Alation

Customer Managed Applies to customer-managed instances of Alation

October 30, 2024

IBM Db2 Database OCF Connector: Version 1.2.1

Fixed Issues

Connector Fails to Extract Foreign Keys After Metadata Extraction for Certain Schemas

Due to trailing white spaces in schema names, the connector fails to extract foreign keys after MDE. The issue occurs as the connector wasn’t able to resolve the referenced primary key schemas due to the schema name mismatch with foreign keys.

This issue is now resolved. (AL-165840)

CHAR(xx) Column Type from DB2 Appears As VARCHAR(xx) on Alation UI

The Alation user interface displays the CHAR(xx) column type from DB2 as VARCHAR(xx).

This issue is now resolved. (AL-173624)

August 14, 2024

IBM Db2 Database OCF Connector: Version 1.2.0

Enhancements

SDK Upgrade

The IBM Db2 OCF connector is now upgraded to the latest SDK version 4.8.16. (AL-161107)

This upgrade addresses the following Common Vulnerabilities and Exposures (CVEs):

CVE-2022-25647, CVE-2023-2976, CVE-2020-8908, CVE-2021-22569, CVE-2021-22570, CVE-2022-3509, CVE-2022-3510, CVE-2022-3171, CVE-2021-29425, CVE-2021-37136, CVE-2021-37137, CVE-2019-20444, CVE-2021-21290, CVE-2021-43797, CVE-2022-24823, CVE-2024-29025, CVE-2021-21295, CVE-2021-21409, CVE-2020-11612, CVE-2019-20445, CVE-2023-34462

OpenJDK Upgrade

The JDK is now upgraded to Temurin-11.0.23+9. This upgrade addresses the following CVEs: CVE-2024-20952 and CVE-2023-20918 (AL-166114)

Support for Authentication Based on AWS Secret Manager Credentials

When installed on an Alation Agent, the IBM Db2 OCF connector now supports authentication using credentials the Agent has fetched from AWS Secrets Manager. For more information, see AWS Secrets Manager for Data Source Authentication Using OCF Connector. (AL-166114)

Note

Support for authentication based on AWS Secret Manager is available for all installations (on-premise and Alation Cloud Service), however, integrating with AWS Secrets Manager through an Alation Agent applies only to cloud native architecture.

March 27, 2024

IBM Db2 Database OCF Connector: Version 2.0.3

Enhancements

Removal of ORDER BY Clause in Default Metadata Extraction Queries

The ORDER BY clause has now been removed from the default Metadata extraction queries.

Processes subsequent to MDE ensure the extracted objects (Schema, Table, and Column) are mapped to the correct hierarchy. Therefore, it is redundant for the connector to fetch ordered items from the data sources. (AL-149896)

Fixed Issues

Metadata Extraction Fails

Metadata extraction fails with the following redundant error message:

MissingFormatArgumentException: Format specifier ‘%s

The connector has now modified the error handling to display appropriate error messages during MDE failure. (AL-147543)