IBM Db2

IBM Db2 is a high-performance, enterprise-grade relational database system designed for reliability, scalability, and transactional integrity.

ingestr supports IBM Db2 as a source.

Installation

Db2 source support is built into the ingestr binary. It does not require the IBM CLI driver, CGO, or a separate Python add-on.

URI format

The URI format for DB2 is as follows:

db2://<username>:<password>@<host>:<port>/<database-name>

URI parameters:

• username: The username to connect to the database
• password: The password for the user
• host: The host address of the database server
• port: The port number the database server is listening
• database-name: the name of the database to connect to

Optional query parameters:

• schema: default schema to use for unqualified table names. If omitted, ingestr uses the username uppercased.
• ssl: set to true or 1 to connect with TLS.
• timeout: connection/read timeout in seconds.