Originally called Raptor – SQL Developer has become quite a decent SQL Development tool over the years. The nice thing about it, besides the fact that it’s free, is that it also works with databases other than Oracle. For instance if you don’t like IBM Data Studio’s clunky interface for your DB2 development, then you may want to try SQL Developer instead.
It is actually quite easy to set it up. First you need to tell SQL Developer where it can find the DB2 JDBC drivers. Second, you create a new Database Connection to the DB2 database.
To include the DB2 JDBC drivers, choose “Preferences” under the “Tools” menu item. In the window that then appears, choose “Third Part JDBC Drivers” under the “Database” section in the navigation tree on the left. Then add the following 2 DB2 drivers, which are normally located under DB2’s sqllite/java directory: db2jcc.jar and db2jcc_license_cu.jar.
After that, simply create a new DB connection. You should now see a new “DB2” tab in the New Connection pop-up window.