IBM Db2

An IBM Db2 client that belongs on a Mac.

Connect to Db2 for Linux, UNIX and Windows from a Mac. IBM's CLI driver is downloaded on first use and checked file by file, and it brings its own console client.

Download for macOS See every feature

Free for the databases on your Mac. Pricing

IBM Db2

What IBM Db2 gets.

The kinds of object that exist on an engine are the kinds the app shows. This is IBM Db2's row of the features table, and what stands behind it.

EngineEditable gridDesignersUsers & RolesDiagram
IBM Db2✓tables with an enforced key✓tables, indexes, triggers, sequences✓✓

The driver, fetched and checked for you

The download comes from IBM, under IBM's own terms. It, the licence text inside it and then every extracted file are checked against SHA-256 digests built into the app; nothing is kept unless all of them match.

Guide: Oracle and IBM Db2 clients

Editable where the key is enforced

A table is editable in the grid when its primary key is enforced. One whose key is not enforced is read-only, and the lock in the status bar says why.

Guide: editing rows in the grid

Users, groups and roles

Db2 accounts come from outside the database, so they can be granted to but not created. The sidebar lists them under Users, Groups & Roles.

Guide: users and roles

db2cli, with the download

A console tab runs db2cli, which comes with the downloaded client. brew install rlwrap gives it history and line editing.

Guide: console tabs
Connect

Connect to IBM Db2.

Click Add Connection under the sidebar and pick the IBM Db2 tile. The first time, click Db2 Client Setup… and then Download. Paste a connection string — the field reads db2:// addresses — or type the host, port, database, user and password. Click Test Connection, then Add.

Default port
50000
SSL
Disabled, or Verify Certificate with an optional Server Certificate
Servers
Db2 for Linux, UNIX and Windows; checked against Db2 Community 12.1. Db2 for z/OS and IBM i are not supported.
Console
db2cli, which comes with the downloaded client. brew install rlwrap gives it history and line editing.
Notes
Needs IBM's CLI driver, downloaded on first use. A table is editable in the grid when its primary key is enforced.

Guide: IBM Db2 in the docs Guide: your first connection

Every engine

One app for the rest of your databases, too.

Every feature is built against one driver contract, so the grid, the designers and the assistant work the same whichever server you open next.

PostgreSQL MySQL MariaDB SQLite SQL Server Oracle IBM Db2 MongoDB Redis DuckDBand CSV files ClickHouse Databricks

Try it on your own database.

Free for the databases on your Mac, and never asking you to sign in.

Download DBClient

$brew install --cask az-code-lab/taps/dbclient