Ispirer Ispirer
 


Ispirer Home Page Ispirer SQLWays Product Page - PowerBuilder Conversion Request SQLWays

ODBC Connection Tuning

For DB2 Mainframe

To create ODBC connect to AS/400 or OS390 please do following:

1) Install “DB2 Connect Personal Edition” from IBM site.

2) Run the “Configuration Assistant” tool and choose “Add Database Using Wizard…” menu.

Then please setup your settings to connect to DB2 AS/400 or z/OS.

3) At step 4 “Data Source” please register system data source and click “Finish” button.

4) Run Wizard and select ODBC connect.

For DB2 Linux, Unix, Windows version

To create ODBC connect to DB2 LUW please do following:

1) Install “IBM Data Server Client” from IBM site.

2) Run the “ODBC Data Source Administration” utility and click “Add” button:

3) Choose the IBM DB2 ODBC Driver:

4) Specify Data source name and click “Add” button:

5) Specify User name and password that will be used to connect to DB2 database on the “Data Source” tab:

6) On the “TCP/IP” tab need to provide the credentials to connect to the database, like db name, db alias, host and a port:

7) After that please click “OK” and you will see new Data Source created for DB2 database:

This Data source should be used in SLQWays Wizard tool to connect to the DB2 database.


Ispirer Home Page Ispirer SQLWays Product Page - PowerBuilder Conversion Request SQLWays

sqlways/users-guide/setting-up-database-connection/db2/odbc-tuning.txt · Last modified: December 28, 2016, 03:02:55 AM by alexandr.kirpichny
 
© 1999-2018, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement