Configuration SQuirreL SQL Client for DB2 database : Execute SQL query from SQuirreL SQL client against DB2

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.

1. Download SQuirreL SQL Client and Download DB2 driver.
2. Start SQuirreL client(It is a jar file,plain java application).
   > java  -jar  <SQUrrel_Jar>
3. 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
   
   
4. Click Extra Class Path tab and browse DB2 driver downloaded above and click Ok.
   
   
5. 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>
   

Now we are ready to execute SQL command from SQuirreL SQL Client. Right click on DB2 Alias and click connect.It opens a worksheet where we can execute SQL command.

---