IBM Db2 Connection¶

The IBM Db2 connection type enables connection to IBM Db2 databases.

Configuring the Connection¶

Host (required)

The host to connect to.

Schema (required)

The Db2 database name to connect to. Maps to the DATABASE keyword in the Db2 connection string.

Login (required)

Specify the user name to connect.

Password (required)

Specify the password to connect.

Port (optional)

Port of the Db2 database. Default is 50000.

Extra (optional)

Specify extra parameters (as a JSON dictionary) that are appended verbatim to the Db2 connection string. Parameter names are converted to uppercase automatically.

Note

Do not put database or protocol here — database is taken from the Schema field above, and protocol is always set to TCPIP by the hook. Values placed in extras for these keys will be appended as duplicates and ignored by the driver.

Common parameters:

SECURITY - Enable SSL (set to "SSL").
SSLServerCertificate - Path to the server SSL certificate.
Any other parameter supported by the IBM Db2 driver.

Example “extras” field for SSL:

{
   "SECURITY": "SSL",
   "SSLServerCertificate": "/path/to/server.crt"
}