I am experienced with DB2 but very new to DB2 Connect. The person installing Linux 390 is new to it, as well, so we are the blind leading the blind right now.

We managed to get DB2 Connect installed and configured on Linux 390 so that it successfully connects to each of our DB2 systems on z/OS. I downloaded a freeware SQL client ("Sui" from www.sui.nu) for my Windows XP system and am trying to make it use DB2 Connect on Linux 390 to talk to the DB2 subsystems on z/OS.

Sui wants the driver and the URL for the database server. For drivers, I have both of the following successfully:

sun.jdbc.odbc.JdbcOdbcDriver

or

COM.ibm.db2.jdbc.app.DB2Driver

providing a use a URL for a local database (which uses an old copy of DB2 Connect I installed on my Windows system a long time ago). That is:

jdbc:odbc:<dbname>

or

jdbc:db2:<dbname>

respectively.

How do I specify the URL for the DB2 Connect system on the Linux 390 server?

I have tried the following with no success:

==============================================
COM.ibm.db2.jdbc.app.DB2Driver
jdbc:db2://<ipaddress>:<dbname>
"java.sql.SQLException: No suitable driver"
==============================================
COM.ibm.db2.jdbc.app.DB2Driver
jdbc:db2://<ipaddress>:50001/<dbname>
"java.sql.SQLException: No suitable driver"
==============================================
sun.jdbc.odbc.JdbcOdbcDriver
jdbc:odbc://<ipaddress>:<dbname>
"java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified"
==============================================
sun.jdbc.odbc.JdbcOdbcDriver
jdbc:odbc://<ipaddress>:50001/<dbname>
"java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified"
==============================================

"ipaddress" is the ipaddress of the Linux system. I have pinged that address, and I am also able to TELNET in with "TELNET <ipaddress> 50001".

Thanks in advance for any help.

John Bloniarz

John,

give a look at the "Connectivity Cheat Sheet" from Raul F. Chong.
http://www-106.ibm.com/developerwork...301chong2.html

HTH,

Rodney:

Thanks. That is a great reference document, especially when using the IBM DB2 client and DB2 Connect. However, it does not spell out the URL I need to use to have SUI (or presumably any other non-IBM SQL client) talk through DB2 Connect on another server.

Still looking for anyone who knows.

Thanks,
John Bloniarz