Purpose

IBM Db2 for Linux, UNIX and Windows (LUW) 11.1 or later.

Connection fields

FieldRule and default valueExplanation
Server (name or IP address)
host
RequiredSet the value according to your service configuration.
Port
port
As configured
Default: 50000
Range: 1–65535
Set the value according to your service configuration.
Database
database
RequiredSet the value according to your service configuration.
User
username
RequiredSet the value according to your service configuration.
SSL/TLS encryption
ssl
As configured
Default: False
Set the value according to your service configuration.
Password
secret
Separate protected fieldThe secret is not displayed after saving. An empty field in an existing connection preserves its current secret.

Setup and validation

  1. Create a connection and give it a clear name.
  2. Complete required fields and the separate secret field.
  3. Run “Test” and read the diagnostics.
  4. Save the connection and select it in the appropriate flow block.

A successful test does not replace checking access to the required object and specific write mode.

Use in a flow

Server and account settings are stored in the connection. The specific object, fields and flow behavior are defined in the block. Go to data-handling rules →