Support
Supported from versions 10.1 to 11.5.
Configuration
Vendor
DB2
Connection format
The connection URL format is
jdbc:db2://<database_host>:<port>/<database>.
Permissions
If full schema access 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 performed.
From version 11.5 onwards, permissions can be granted on a full schema in order 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 different 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; review the documentation indicated above.
Tables with characters in the name
This technology allows characters such as "/" in the name; if these are being used, the path-separator must be configured with a character other than "/". See File extraction for more details.