Ispirer Ispirer
 


Ispirer Home Page Request SQLWays

What DB2 AS400 Client To Use For ODBC Connection Tuning

When trying to tune the ODBC connection to the DB2 AS 400 you may have some doubts regarding which DB2 Client to chose. According to the IBM documentation, you can use two tools to connect to the DB2 AS 400:

  • IBM iSeries Access for Windows client (Recommended Client)
  • DB2 Connect tools

If you will use one of the DB2 Connect tools for tuning the ODBC connection, you will need to have the appropriate license file, that will allow you to connect to the DB2 AS 400 database. The license file is distributed as part of the DB2 Connect products, so the only way to obtain this license key file is to purchase one of the following DB2 Connect products:

  • DB2 Connect Personal Edition
  • DB2 Connect Enterprise Edition
  • DB2 Connect Application Server Edition
  • DB2 Connect Unlimited Edition for System z®
  • DB2 Connect Unlimited Edition for System i®

The relevant license file can be located on the DB2 Connect install image in the /db2/license directory.

ODBC Tuning Using IBM iSeries Access Client

Step by step guide on how to tune the ODBC connection to the IBM DB2 AS/400 database with the help of iAccess client, you can find using the following link:

ODBC Tuning Using DB2 Connect Tools

Step by step guide on how to tune the ODBC connection to the IBM DB2 AS/400 database with the help of DB2 Connect tools, you can find using the following link. In this guide there is a detailed description of the tuning process using the DB2 Connect Personal Edition:



If you will have additional questions regarding the ODBC Connection tuning to the DB2 AS400, please contact our support team: support@ispirer.com


Ispirer Home Page Request SQLWays

sqlways/users-guide/setting-up-database-connection/db2/what-driver-to-use.txt · Last modified: September 04, 2018, 10:44:10 AM by alexandr.kirpichny
 
© 1999-2018, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement