Background

As always coming back to DBeaver.

This time to connect to a UDB Instance running on Linux.

BTW, UDB means Universal Database.

UDB JDBC Driver

Artifacts

DB2 JDBC Driver Versions and Downloads

The URL for DB2 JDBC Drivers is Link.

Here is a current snapshot.

v11.1 FP0 ( GA )

We chose the v11 FP0 ( GA ) which is a baseline install; specifically 4.21.29.

Others might choose v11 M3 FP3; which includes the latest patches.

The URL is Link.

Here is a screen shot:

IBM Data Server Driver for JDBC and SQLJ ( JCC Driver )

As all we need is the JDBC Driver, we chose “IBM Data Server Driver for JDBC and SQLJ (JCC Driver)“.

One needs membership account to actually download, so please login in with one if you have already registered.  Else, please create one, as it is free.

Download

In short, we downloaded “IBM Data Server Driver for JDBC and SQLJ (JCC Driver)“.

Extracted

Image

Textual

1. db2jcc.jar
   • JDBC v3.0
2. db2jcc4.jar
   • JDBC 4.0

Preparation

Network

Port Number

Let us determine the Network Port Number that our DB/2 Instance is listening on.

db2 get dbm cfg

Syntax

db2 get dbm cfg

Sample

db2 get dbm cfg | grep SVCE

Output

Databases

Outline

Let us determine the list of databases that are available on our UDB Instance.

db2 list database directory

Syntax

 db2 list database directory

Sample

 db2 list database directory | grep "Database name"

Output

 

DBeaver

Database

Connections

Steps

Select new connection type

Image

Textual

1. DB2
   • DB2 LUW

Driver settings – Download driver files

Image

Textual

1. Click on the “Add JARs” button

Driver settings – Edit Driver – Add File – Post

Image

Textual

1. JAR file “db2jcc4.jar” added

Create new connection – DB2 Connection Settings – Tab – General

Image

Textual

1. Host
2. Port
3. Database
4. username
5. Password

Create new connection – DB2 Connection Settings – finish connection creation

Image

 

References

1. IBM
   • Home > DB2 for Linux UNIX and Windows 9.5.0 > Database administration > Administrative interfaces > Administrative SQL routines and views > Supported routines and views > Snapshot routines and views
     • APPLICATIONS administrative view – Retrieve connected database application information
       Link