Topic
  • 9 replies
  • Latest Post - ‏2014-03-05T08:47:02Z by tomliotta
SystemAdmin
SystemAdmin
3129 Posts

Pinned topic Need help connecting TOAD for DB2 to AS/400

‏2006-05-10T21:26:55Z |
I have installed TOAD for DB2 and it told me I needed to have IBM Run-time Client v8.1.6 or later in order for it to work. So, I downloaded and installed v8.1.11 and have tried to configure the ODBC connection, but I keep getting a message that says "SQL8002N Connect processing failed; a valid product license was not found. SQLSTATE=42968"

What license is it referring to? Could it just be a configuration issue? And if so, can you provide some assistance in the connection setup?

Thanks!
Updated on 2006-10-25T04:16:27Z at 2006-10-25T04:16:27Z by andrewwang1@yahoo.com
  • mspringgay
    mspringgay
    2 Posts

    Re: Need help connecting TOAD for DB2 to AS/400

    ‏2006-05-11T14:18:59Z  
    The DB2 Run-time Client is licenced for DB2 for Linux, Unix and Windows servers. In order to connect to DB2 for iSeries you need a licence for DB2 Connect. DB2 Connect includes the DB2 Run-time Client.

    You can find information on DB2 Connect here: http://www-306.ibm.com/software/data/db2/db2connect/
  • SystemAdmin
    SystemAdmin
    3129 Posts

    Re: Need help connecting TOAD for DB2 to AS/400

    ‏2006-05-11T14:35:28Z  
    The DB2 Run-time Client is licenced for DB2 for Linux, Unix and Windows servers. In order to connect to DB2 for iSeries you need a licence for DB2 Connect. DB2 Connect includes the DB2 Run-time Client.

    You can find information on DB2 Connect here: http://www-306.ibm.com/software/data/db2/db2connect/
    Is that different than Client Access for IBM iSeries? If so, how?
  • SystemAdmin
    SystemAdmin
    3129 Posts

    Re: Need help connecting TOAD for DB2 to AS/400

    ‏2006-05-12T19:16:45Z  
    Is that different than Client Access for IBM iSeries? If so, how?
    emily.wilson@weyerhaeuser.com wrote:
    > Is that different than Client Access for IBM iSeries? If so, how?

    Yes it is different product. Client Access for IBM iSeries is a client
    for accessing iSeries servers including DB2 for iSeries functionality.
    DB2 Connect is a licensed product that can be used to access any of the
    DB2 Family of database servers.
  • SystemAdmin
    SystemAdmin
    3129 Posts

    Re: Need help connecting TOAD for DB2 to AS/400

    ‏2006-10-10T17:37:50Z  
    Hy,
    I would like to install TOAD for AS400 - DB2.

    I have a donwloaded copy from http://www.toadsoft.com/ but when I try to configure a new conexion the software doesn't give me the oportinity to choose the AS400 Operative System I can only choose AIX, Linux, etc.

    Where did you find the TOAD for AS400 - DB2 ???

    Could you please send me the web address ???

    Thank you so much.
  • andrewwang1@yahoo.com
    40 Posts

    Re: Need help connecting TOAD for DB2 to AS/400

    ‏2006-10-25T04:16:27Z  
    Hy,
    I would like to install TOAD for AS400 - DB2.

    I have a donwloaded copy from http://www.toadsoft.com/ but when I try to configure a new conexion the software doesn't give me the oportinity to choose the AS400 Operative System I can only choose AIX, Linux, etc.

    Where did you find the TOAD for AS400 - DB2 ???

    Could you please send me the web address ???

    Thank you so much.
    DB2 UDB for zOS, for LUW and for iSeries are 3 different products, although they all called DB2 UDB. Make sure the TOAD for DB2 can support DB2 UDB for iSeries first. As I know iSeries Navagator seems the one and only one the most suitable toll for interfacing DB2 UDB for iSeries, even the 'Control Center'(comes with DB2 UDB for LUW) can only connect to iSeries but can do nothing with iSeries.
  • jemason1
    jemason1
    3 Posts

    Re: Need help connecting TOAD for DB2 to AS/400

    ‏2014-03-04T12:27:36Z  

    Connecting to DB2 on the iSeries ( ibm i ) is not simple. For the last decade to make it easy to work with DB2 and low-cost, I've skipped using:

    * TOAD

    * DB2 Connect

    * Client Access

    Instead I rely on using the built-in, free JDBC support with the Java Toolkit or JTOpen version ( downloadable from SourceForge). If the iSeries server is setup with TCP for remote database access ( most are by default ), using the jar file ( jt400.jar ) from the Java Toolkit makes it VERY simple to connect using really good free, open-source database tools that work with ALL databases: DB2, Oracle, SQL Server, MySQL etc. I don't like using a tool for 1 server only when I work on more than one type of server. As a result, I can use one of 2 excellent, free SQL clients:

    1> Oracle SQL Developer   (  http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html )

    2> Squirrel SQL Client (  http://squirrel-sql.sourceforge.net/ )

    Both are excellent tools, well-supported, widely used across many databases making it simple to learn 1 tool and support many different databases. I just add the jt400.jar file to the classpath for either tool, create a database connection to the server I want and I'm done.

  • jemason1
    jemason1
    3 Posts

    Re: Need help connecting TOAD for DB2 to AS/400

    ‏2014-03-04T12:29:32Z  

    Connecting to DB2 on the iSeries ( ibm i ) is not simple. For the last decade to make it easy to work with DB2 and low-cost, I've skipped using:

    * TOAD

    * DB2 Connect

    * Client Access

    Instead I rely on using the built-in, free JDBC support with the Java Toolkit or JTOpen version ( downloadable from SourceForge). If the iSeries server is setup with TCP for remote database access ( most are by default ), using the jar file ( jt400.jar ) from the Java Toolkit makes it VERY simple to connect using really good free, open-source database tools that work with ALL databases: DB2, Oracle, SQL Server, MySQL etc. I don't like using a tool for 1 server only when I work on more than one type of server. As a result, I can use one of 2 excellent, free SQL clients:

    1> Oracle SQL Developer   (  http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html )

    2> Squirrel SQL Client (  http://squirrel-sql.sourceforge.net/ )

    Both are excellent tools, well-supported, widely used across many databases making it simple to learn 1 tool and support many different databases. I just add the jt400.jar file to the classpath for either tool, create a database connection to the server I want and I'm done.

  • jemason1
    jemason1
    3 Posts

    Re: Need help connecting TOAD for DB2 to AS/400

    ‏2014-03-04T12:29:35Z  

    Connecting to DB2 on the iSeries ( ibm i ) is not simple. For the last decade to make it easy to work with DB2 and low-cost, I've skipped using:

    * TOAD

    * DB2 Connect

    * Client Access

    Instead I rely on using the built-in, free JDBC support with the Java Toolkit or JTOpen version ( downloadable from SourceForge). If the iSeries server is setup with TCP for remote database access ( most are by default ), using the jar file ( jt400.jar ) from the Java Toolkit makes it VERY simple to connect using really good free, open-source database tools that work with ALL databases: DB2, Oracle, SQL Server, MySQL etc. I don't like using a tool for 1 server only when I work on more than one type of server. As a result, I can use one of 2 excellent, free SQL clients:

    1> Oracle SQL Developer   (  http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html )

    2> Squirrel SQL Client (  http://squirrel-sql.sourceforge.net/ )

    Both are excellent tools, well-supported, widely used across many databases making it simple to learn 1 tool and support many different databases. I just add the jt400.jar file to the classpath for either tool, create a database connection to the server I want and I'm done.

  • tomliotta
    tomliotta
    44 Posts

    Re: Need help connecting TOAD for DB2 to AS/400

    ‏2014-03-05T08:47:02Z  
    • jemason1
    • ‏2014-03-04T12:29:35Z

    Connecting to DB2 on the iSeries ( ibm i ) is not simple. For the last decade to make it easy to work with DB2 and low-cost, I've skipped using:

    * TOAD

    * DB2 Connect

    * Client Access

    Instead I rely on using the built-in, free JDBC support with the Java Toolkit or JTOpen version ( downloadable from SourceForge). If the iSeries server is setup with TCP for remote database access ( most are by default ), using the jar file ( jt400.jar ) from the Java Toolkit makes it VERY simple to connect using really good free, open-source database tools that work with ALL databases: DB2, Oracle, SQL Server, MySQL etc. I don't like using a tool for 1 server only when I work on more than one type of server. As a result, I can use one of 2 excellent, free SQL clients:

    1> Oracle SQL Developer   (  http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html )

    2> Squirrel SQL Client (  http://squirrel-sql.sourceforge.net/ )

    Both are excellent tools, well-supported, widely used across many databases making it simple to learn 1 tool and support many different databases. I just add the jt400.jar file to the classpath for either tool, create a database connection to the server I want and I'm done.

    Connecting to DB2 on the iSeries ( ibm i ) is not simple. For the last decade to make it easy to work with DB2 and low-cost, I've skipped using:

    * TOAD

    * DB2 Connect

    * Client Access

    Including "Client Access" in that list is not easy to understand. First, the name is years out of date, so it's not clear if the name is being used generically to refer to all subsequent products or if it actually refers to the old "Client Access" product.

    But because it's not particularly difficult to install or use (for remote SQL/ODBC/JDBC/OLE DB/.NET) in its later versions and it's free (for remote SQL), I'd be interested in knowing more about what the criteria were.

    It's also handy to have IBM support for it.

    Tom