Ibm Db2

Category: Database Connectors

Introduction

This document is created to help setup a mindzieDataDesigner connector to IBM DB2 database. The mindzieDataDesigner is the ETL tool used by mindzieStudio to convert database tables to process mining event logs. The purpose of this document is to help creating the connection string and opening ports on the firewall if required.

Overview

The IBM DB2 connector provides connectivity to IBM DB2 databases across various platforms including z/OS, Linux, Unix, and Windows. This connector supports both traditional DB2 LUW (Linux, Unix, Windows) and DB2 for z/OS mainframe environments.

System Requirements

Database System: IBM DB2 LUW 11.1 or later, DB2 for z/OS
Platform Support: Windows, Linux, Unix, z/OS
Cloud Support: IBM Db2 on Cloud, IBM Cloud Pak for Data
Dependencies: IBM Data Server Driver or IBM DB2 Client

Connection String Format

Basic Format

Database=database_name;Server=hostname:port;UID=username;PWD=password;

Connection Examples

Local DB2 Database

Database=SAMPLE;Server=localhost:50000;UID=db2admin;PWD=password;

Remote DB2 Server

Database=PRODDB;Server=db2server.company.com:50000;UID=mindzie_user;PWD=SecurePassword123;

DB2 on Cloud

Database=BLUDB;Server=dashdb-entry.services.dal.bluemix.net:50000;UID=username;PWD=CloudPassword123;

Connection with SSL

Database=SECUREDB;Server=db2server:50001;UID=username;PWD=password;Security=SSL;

mindzie Server Access: For enhanced security, you can configure your firewall to only allow connections from mindzie servers by whitelisting specific IP addresses. Contact mindzie support to obtain the current IP addresses for the mindzie servers you are using.

Official Documentation: IBM Db2 Documentation
IBM Data Server Driver: IBM Data Server Clients

💡 Tip: For mainframe DB2 connections, work with your z/OS systems administrator to configure proper network connectivity and security settings.