Acceldata
 ADOC
Search documentation… ⌘K

Last updated: Sep 29, 2026 09:28 UTC

IBM DB2

IBM DB2 is a powerful relational database management system (RDBMS) designed to store, manage, and retrieve structured data at scale. Known for its scalability, reliability, and enterprise-grade performance, DB2 is widely used in industries that require secure and efficient management of mission-critical data.

Prerequisites

Ensure the following requirements are met before you connect DB2 as a data source:

  • DB2 Access Details: JDBC connection information (hostname, port, username, and password).
  • ADOC Account & Permissions: Access rights to add new data sources in your ADOC environment.
  • Data Plane: An existing data plane in ADOC or readiness to create one for DB2 ingestion. See the Data Plane Installation documentation for more information.

Add IBM DB2 as a Data Source

Step 1: Start Setup

  • Navigate to the left main navigation menu, click Control Center -> Integrations.
  • From the Integrations page, click Add Data Source and select IBM DB2 from the list.
  • On the Data Source Details page:
    • Enter a name and optional Description for the data source.
    • Enable the Data Reliability toggle and select the data plane.
  • Click Next.

Step 2: Enter Connection Details

To connect to your ClickHouse database:

  • Enter your JDBC URL in the format: jdbc:db2://<host>:<port>/<database>
  • Enter your username and password (or select a secret manager)
  • Click Test Connection. A "Connected" message will appear if successful. Otherwise, re-check your credentials, JDBC URL, and format.

Step 3: Set Up Observability

Now define what ADOC should monitor in ClickHouse.

  • Select the DB2 schemas or databases you want ADOC to monitor.
  • Use Crawler Execution Schedule to set when background jobs scan files and collect metadata for observability:
    • Select how often the crawler runs (e.g., daily)
    • Set execution time and time zone
    • Add multiple execution schedules if needed
  • Configure Notifications
    • Notify on Crawler Failure: Select one or more channels for failure alerts.
    • Notify on Success: Receive success notifications (toggle on/off)
  • Click Submit to save your configuration and start monitoring your ClickHouse data source.

Your DB2 data source will now appear on the Data Sources page.

What’s Next?

  • Create and Apply Policies: Define observability policies such as data quality, reconciliation, schema drift, data drift, and anomaly detection. Without policies, dashboards will not show metrics.
  • Monitor Dashboards: Use ADOC dashboards to track applied policies, detect anomalies, and assess DB2 data health.
  • Set Up Alerts: Configure proactive alerts to respond quickly to schema changes or data quality issues.