Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003
    Posts
    2

    Unanswered: Accessing DB2 Connect On Linux 390

    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
    Last edited by JWBloniarz; 12-12-03 at 12:14.

  2. #2
    Join Date
    Feb 2002
    Location
    Germany
    Posts
    141
    John,

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

    HTH,
    Rodney Krick

  3. #3
    Join Date
    Dec 2003
    Posts
    2
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •