Bring Order to Sprawling IBM DB2 Catalogs

DbSchema imports IBM DB2 catalog metadata from the SYSCAT views into interactive ER diagrams, then adds schema comparison, reviewed migration DDL, and documentation — one desktop app for Windows, macOS, and Linux.

Map tables and foreign keys from many schemas on one canvas
Spot undocumented dependencies before a migration touches them
Diff two environments and audit the DDL before it deploys
Autocomplete DB2 objects and functions while writing SQL

available for

ISO-27001 certified

Free Community Edition No signup required 15-day Architect trial included

Free Download

DbSchema turning an IBM DB2 catalog into an interactive ER diagram

Trusted by teams at

Years of Production Tuning
and Not One Current Diagram

An enterprise DB2 catalog accumulates schemas, stored procedures, triggers, tablespaces, and partitioning decisions over decades. SYSCAT holds the truth — one query at a time, readable mainly to the person who already knows the answer.

DbSchema imports that metadata once and turns it into navigable diagrams, an offline model, and documentation that keeps pace with the catalog.

Navigate, Diff & Script
DB2 Schemas Visually

The catalog on a canvas, every change audited before it ships.

Organize IBM DB2 schemas into focused diagrams

Many Schemas, One Canvas

Bring tables, views, and foreign keys from multiple DB2 schemas into focused diagrams — and see cross-schema dependencies and orphaned tables before a migration does.

Compare IBM DB2 environments and generate migration DDL

Migrations You Audit First

Diff test against production — or the model against either — review the differences side by side, and generate DDL covering exactly the approved changes.

Write DB2 SQL with autocomplete in DbSchema

An Editor That Knows Your Objects

Autocomplete for DB2 syntax, catalog objects, and built-in functions; run against the live connection and review result sets in place.

DB2 Changes That Arrive
as Reviewed Commits

Keep the model under version control and the catalog gains what your code always had: branches, reviews, an audit trail. When a change is approved, DbSchema writes the DDL that carries it into each environment.

IBM DB2 schema synchronization between the Git model and database environments

Read Git Workflow Docs

DB2 Connection Essentials

IBM's Data Server Driver for JDBC and SQLJ ships as a zip whose db2jcc4.jar is the JDBC 4.0 driver current Java versions use — the legacy db2jcc.jar and an optional license jar sit beside it. Download and registration steps are on the Db2 JDBC driver page. The URL follows jdbc:db2://host:50000/DBNAME with a case-sensitive database name; 50000 is the common default on Linux, Unix, and Windows. Confirm TCP/IP is enabled (db2set DB2COMM=TCPIP) and connect as a user with CONNECT privilege — DbSchema then imports the SYSCAT metadata into the diagram.