Support
Support from versions 10.1 to 11.5.
Configuration
Vendor
DB2
Connection format
The connection URL format is
jdbc:db2://<database_host>:<port>/<database>.
Permissions
In the event that access to the full schema is not desired, the user or role used needs the SELECT permission on the tables from which metadata is to be extracted or data sampling is to be performed.
From version 11.5 onwards, permissions can be granted over an entire schema to extract metadata or perform data sampling; a user or role with the SELECTIN permission on the schema is required.
Metadata extraction
Below is the IBM documentation for db2 showing the various fields extracted from the tables *:
https://www.ibm.com/docs/en/db2-for-zos/12?topic=functions-sqlcolumns-get-column-information
Important → For some column types, the length observed in the table may differ from the one extracted by Anjana; refer to the documentation indicated above.
Tables with special characters in the name
This technology allows characters such as “/” in the name; if they are being used, the path-separator must be configured with a character other than “/”. See File extraction for more details.