Summary: in this tutorial, you will learn how to interact with Db2 database servers using the SQL Developer tool.
Summary: in this tutorial, you will learn how to interact with Db2 database servers using the SQL Developer tool. SQL Developer is a free Database IDE that allows you to interact with databases using a graphical user interface instead of command-line tools like Db2 command line or Db2 command line plus. For example, IBM Data Server Driver for JDBC and SQLJ type 4 connectivity from the IBM Data Server Driver for JDBC and SQLJ version 3.61, which is shipped with Db2 on Linux®, UNIX, and Windows systems Version 9.7 Fix Pack 3, to a Db2 on Linux, UNIX, and Windows systems Version 8 database is supported.
Progress DataDirect Connect and Connect64 for ODBC DB2 Wire Protocol Driver Version 7.1.6 (32- and 64-bit drivers are available for all supported databases and platforms unless otherwise noted.) ODBC Version Support. Compatible with ODBC 3.8 applications; Database Support. DB2 v11.1 for Linux, UNIX, Windows and higher. 'db2ibmiibm' for IBMi PDOIBM connection 'db2zosodbc' for zOS ODBC connection 'db2expresscodbc for Express-C ODBC connection; Then if driver is 'db2.odbc', database must be set to ODBC connection name. If driver is 'db2ibmiibm', database must be set to IBMi database name (WRKRDBDIRE). Option 2: Configure DB2 using package config file.
SQL Developer is a free Database IDE that allows you to interact with databases using a graphical user interface instead of command-line tools like Db2 command line or Db2 command line plus. In the past, SQL Developer solely supported Oracle Database. However, by using third party plugins, you can use SQL developer to work with other database systems such as MySQL, SQL Server, or IBM Db2.
Download SQL Developer
Click the following link to download the SQL Developer program.
Note that you need to create an Oracle account in case you don’t have one before you can download it.
Download Plugin
Click the following link to download the JDBC Db2 driver version:
Connect to Db2 Using SQL Developer
Launch SQL Developer and follow these steps:
Step 1. Choose Tools > Preferences… menu item:
Step 2
Search for JDBC, you will find the Third Party JDBC Drivers under Database. Click the Add Entry… button
Step 3
Browse to the location that you store the JDBC driver file, in this case, it is db2jcc.jar under d:software directory. Click the Select button to choose the JDBC driver file and click the OK button to accept the JDBC driver.
Step 4
Db2 Database Driver Download Free Photography Photos
Click the New button to create a connection to the Db2 database server.
Step 6
Db2 Database Driver Download Free Photography Books
Choose the database connection and click the OK button
Db2 Database Driver Download Free Photography Portfolio Templates
Step 7
- Click the DB2 tab
- Provide the connection details including connection name, user, password, hostname port, and the database (Books) that you want to connect.
- Click the Test button to test the connection. If you see the status: success, it shows that the connection is fine.
- Click the Save button to save the connection and then click the Connect button to connect to the Books database on the local DB2 database server.
Driver Download
Step 8
You will see the following query editor.
Db2 Database Driver Download Free Photography Video Clip
Enter the following command and click the Run button, you will get the output:
In this tutorial, you have learned how to use the SQL Developer to interact with a database on the Db2 database server.