IBM Db2 for LUW agent

Target IBM Db2 for LUW

Prerequisites

To have Gluesync working on your DB2 instance you will need to have:

valid user credentials with permission to read, and write to the target tables and respective database

Setup via Web UI

Hostname / IP Address: DNS record or IP Address of your server;
Port: Optional, defaults to 50000;
Database name: Name of your target database;
Username: Username with read & write access role to target Namespace;
Password: Password belonging to the given username.
Character encoding: Optional, defaults to UTF-8 to read data with different encoding.

Setup via Rest APIs

Here’s an example of calling the Core Hub’s REST API via curl to set up the connection for the IBM DB2 LUW agent:

curl --location --request PUT 'http://core-hub-ip-address:1717/pipelines/{pipelineId}/agents/{agentId}/config/credentials' \
--header 'Content-Type: application/json' \
--header 'Authorization: ••••••' \
--data '{
        "hostCredentials": {
        "connectionName": "myDB2LUWAgent",
        "host": "db2-server-address",
        "port": 50000,
        "databaseName": "your_database_name",
        "username": "db2admin",
        "password": "your_secure_password"
      },
      "specificConfiguration": {
        "characterEncoding": "UTF-8"
      },
}'