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
- db2jcc.jar
- JDBC v3.0
- 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
- DB2
- DB2 LUW
Driver settings – Download driver files
Image
Textual
- Click on the “Add JARs” button
Driver settings – Edit Driver – Add File – Post
Image
Textual
- JAR file “db2jcc4.jar” added
Create new connection – DB2 Connection Settings – Tab – General
Image
Textual
- Host
- Port
- Database
- username
- Password
Create new connection – DB2 Connection Settings – finish connection creation
Image
References
- 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
- APPLICATIONS administrative view – Retrieve connected database application information
- 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
I have a login error, which information is exactly used for the following?
Host
Port
Database
username
Password
Jana :
I think you should work with your Database Administrator as they will have this information readily available to you. Feel free to capture the error screen and post to image sharing site such as https://pasteboard.co/, https://imagebin.ca/.
I am on linkedin.com. My URL is https://www.linkedin.com/in/danieladeniji/.
Please feel free to connect with me and I will be glad to share my email.
Best,
Daniel