- Download SQuirreL SQL Client and Download DB2 driver.
- Start SQuirreL client(It is a jar file,plain java application). Open Driver list from left menu, click the plus sign "Create a New Driver". Fill the popup window as per following guidance and diagram.
Name = Any_name_as_per_convinience<IBM DB2 Universal Driver>
Example URL = jdbc:db2://<server_address>:<port>/<dbname>
website URL = www.ibm.com (optional)
Class Name = com.ibm.db2.jcc.DB2Driver
- Click Extra Class Path tab and browse DB2 driver downloaded above and click Ok.
- Create an alias out of this Driver created above. Open Aliases list and click plus - Create a new Alias. Fill out the popup window,Test connection and press Ok.
Name = Any_name_as_per_convinience
Driver = select driver same as created above(IBM DB2 Universal Driver)
UserName = <username>
Password = <passoword>
SQuirreL SQL Client is a graphical SQL client written in Java that allows us to view the structure of a JDBC compliant database, browse the data in tables, issue SQL commands etc. Follow below steps to configure SQuirreL for DB2 database.
Location: Hyderabad, Telangana, India