I've created an IBM DB2 database named MIRdb, and then tried to connect to it using the Squirrel SQL Client version 3.4.0.

The driver is:
    Name: IBM DB2 App Driver
    Example URL: jdbc:db2:<dbname>
    Class Name: COM.ibm.db2.jdbc.app.DB2Driver
    Extra Class Path:
        C:\Program Files\IBM\SQLLIB\java\db2java.zip
        C:\Program Files\IBM\SQLLIB\java\db2jcc.jar
        C:\Program Files\IBM\SQLLIB\java\db2jcc4.jar
        C:\Program Files\IBM\SQLLIB\java\sqlj.zip
        C:\Program Files\IBM\SQLLIB\java\sqlj4.zip
        C:\Program Files\IBM\SQLLIB\BIN

(my understanding is that I only need the db2java.zip, but I included the rest when it didn't work)

The alias is:
    Name: MIRdb
    Driver: IBM DB2 App Driver (which as a check mark indicating it was loaded)
    URL: jdbc:db2:MIRdb
    User name: db2admin
    Password:

When I try to connect to the alias, I enter the password, click the Connect button and get an Error window stating:
"Unexpected Error occurred attempting to open an SQL connection."

and clicking on the Stack Trace button, I see:
java.util.concurrent.ExecutionException: java.lang.RuntimeException: java.sql.SQLException: Unable to create connection. Check your URL.
    at java.util.concurrent.FutureTask$Sync.innerGet(Unknown Source)
    at java.util.concurrent.FutureTask.get(Unknown Source)
    at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.awaitConnection(OpenConnectionCommand.java:132)
    at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.access$100(OpenConnectionCommand.java:45)
    at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand$2.run(OpenConnectionCommand.java:115)
    at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
    at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
    at java.util.concurrent.FutureTask.run(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.RuntimeException: java.sql.SQLException: Unable to create connection. Check your URL.
    at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.executeConnect(OpenConnectionCommand.java:171)
    at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.access$000(OpenConnectionCommand.java:45)
    at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand$1.run(OpenConnectionCommand.java:104)
    ... 6 more
Caused by: java.sql.SQLException: Unable to create connection. Check your URL.
    at net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:136)
    at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.executeConnect(OpenConnectionCommand.java:167)
    ... 8 more

I am able to start an IBM DB2 command line processor window and connect to MIRdb using the same userid and password.

Am I missing something obvious?

Peter Dow, IT Specialist
Montessori In Redlands
909 793-9050