How to Connect to DB2 With SQL Developer

Written by usha dadighat
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Connect to DB2 With SQL Developer
(Comstock/Comstock/Getty Images)

Oracle offers the SQL Developer as a free tool designed to help programmers work with Oracle databases. SQL Developer provides graphical representations that show programmers the results of queries. It also aids in the debugging process of PL/SQL programming. SQL Developer runs on Windows, Mac and Linux. It also can connect to other databases, such as IBM's DB2 database system, to copy tables and data, as well as helping programmers to develop SQL code for those other database systems.

Skill level:


  1. 1

    Open SQL Developer. Click "File" in the top toolbar menu and click "Open connection."

  2. 2

    Click the "DB2" tab in the Connection dialogue box. Enter the name of the DB2 database in the first box. Enter the host and port information, as well as the driver type. You can choose between entering "IBM DB2 Application Driver" or "IBM DB2 Network Driver" for the driver type. Enter the user name and password to access the DB2 database.

  3. 3

    Click "Info" at the bottom of the Connection dialogue box to test the connection with the settings you entered. Click "OK" to create the connection to the DB2 database.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.