IBM DB2
This connector support IBM DB2 for i-series (as400) and IBM DB2 for z/OS databases. IBM DB2 for LUW is not yet fully supported. The default import query that Katalogue uses has been tested on IBM DB2 for i-series version 11 and z/OS. A custom import query is probably required to make this connector work with IBM DB2 for LUW databases.
Installation
Section titled “Installation”The IBM DB2 connector need some attention to install correctly. See the api/Dockerfile for more information. It might also require a license file to work, if the IBM DB2 server is not configured with server side licensing. More info: https://www.npmjs.com/package/ibm_db
Configuration
Section titled “Configuration”Code page and special characters encoding
Section titled “Code page and special characters encoding”On some occasions, special characters like åäö get wrong encoding when importing data to Katalogue. If this happens, the code page of the connector must be configured to match the source database.
The code page is configured in the GUI, in the Settings -> Connectors -> IBM DB2 section. See https://www.ibm.com/docs/en/db2/11.5?topic=support-supported-territory-codes-code-pages for available code pages
Note that this setting applies globally to all IBM DB2 connections in Katalogue, i.e. setting a specific code page configuration for each IBM DB2 connection is currently not supported.
Usage Notes
Section titled “Usage Notes”DB2 z/OS max column length is set to 30. This means that we cannot use e.g. the Katalogue column name “dataset_technical_definition_raw” (32 characters). References: https://www.ibm.com/docs/en/db2-for-zos/13.0.0?topic=db2-catalog-tables