BroadSQL Download
Documentation / Connect to your database: IBM Db2

Connect to IBM Db2

Add IBM's JDBC driver, db2jcc4.jar, once, then connect with a type 4 URL.

DriverNot bundled: download IBM's JDBC driver (db2jcc4.jar) and copy it into drivers.
Type to choose in ADD CONNECTION or CONFIGDB2
URL formatjdbc:db2://<host>:<port>/<database>
Examplejdbc:db2://dbhost:<port>/MYDB
Where the URL format comes fromIBM Db2: URL format for type 4 connectivity, checked October 17, 2026
Verified with BroadSQLNot verified with BroadSQL by the BroadSQL team: the URL format comes from IBM's documentation.

Steps

  1. Download the driver that matches your Db2 version from IBM's Db2 JDBC driver versions and downloads page, and copy db2jcc4.jar into drivers. Restart BroadSQL.
  2. SHOW DRIVERS; must list the IBM driver.
  3. ADD CONNECTION HR_QA; (or CONFIG; on Windows), type DB2, URL jdbc:db2://<host>:<port>/<database>, then your Db2 user and password.
  4. PING HR_QA;, then CONNECT HR_QA;.

Ask your DBA for the port of the Db2 server: it depends on how the instance was configured.

On Db2

  • DDL statements do not force a commit on Db2, so BroadSQL can roll them back with the transaction.
  • SET PASSWORD does not change a Db2 password: change it with your Db2 or system tools, then update BroadSQL with EDIT CONNECTION.

Found something wrong or unclear on this page? , with the page address.