Differences

This shows you the differences between two versions of the page.

--- knowledge-base:database-migration:setup-and-troubleshooting:db2-as400:odbc-driver-configuration [2018/09/04 10:45]
+++ knowledge-base:database-migration:setup-and-troubleshooting:db2-as400:odbc-driver-configuration [2023/12/14 11:50] (current)
volha.zhyrava
@@ Line 1: / Line 1: @@
+\\
+[[https://www.ispirer.com|Ispirer Website]]
+[[https://www.ispirer.com/products/db2-migration|Ispirer Capabilities: DB2 Migration]]
+[[https://www.ispirer.com/download/download-demo|Free Trial]]
+====== IBM DB2 AS/400 (iSeries): ODBC Connection Tuning ======
+==== For DB2 Mainframe ====
+=== Using DB2 Connect Personal Edition ===
+To tune the ODBC connection to AS/400 you should fulfill the following steps:
+)      Download and install “DB2 Connect Personal Edition” from IBM site.
+)      Open the “Configuration Assistant” tool and select the “Add Database Using Wizard…” menu item.
+{{:knowledge-base:database-migration:setup-and-troubleshooting:db2-as400:db2as400_odbc_conf_1.png?nolink|}}
+Then set up the appropriate settings to connect to DB2 AS/400.
+)	Select "Manually configure a connection to a database" radiobutton.
+{{:knowledge-base:database-migration:setup-and-troubleshooting:db2-as400:db2as400_odbc_conf_2.png?nolink|}}
+)	At the next step choose the TCP/IP protocol and switch on the database physically resides on a host or OS/400 system option
+{{:knowledge-base:database-migration:setup-and-troubleshooting:db2-as400:db2as400_odbc_conf_3.png?nolink|}}
+)	At the "TCP/IP" step provide host name or IP address, set up the Service Name and port number. Click on "Next".
+{{:knowledge-base:database-migration:setup-and-troubleshooting:db2-as400:db2as400_odbc_conf_4.png?nolink|}}
+)	At the next step, provide database name and alias and click on "Next" button.
+{{:knowledge-base:database-migration:setup-and-troubleshooting:db2-as400:db2as400_odbc_conf_5.png?nolink|}}
+)	At the "Data Source" step please switch on the "Register this database for CLI/ODBC" option, provide the ODBC Connection name and click on "Next".
+{{:knowledge-base:database-migration:setup-and-troubleshooting:db2-as400:db2as400_odbc_conf_6.png?nolink|}}
+)      At the "Node Options" step select the Operating System and click on "Finish" button:
+{{:knowledge-base:database-migration:setup-and-troubleshooting:db2-as400:db2as400_odbc_conf_7.png?nolink|}}
+)      In the pop-up window, please press on "Test Connection" button:
+{{:knowledge-base:database-migration:setup-and-troubleshooting:db2-as400:db2as400_odbc_conf_8.png?nolink|}}
+)     Select "ODBC", set up the user name and password and click on "Test Connection" button:
+{{:knowledge-base:database-migration:setup-and-troubleshooting:db2-as400:db2as400_odbc_conf_9.png?nolink|}}
+)     Thus, if all the credentials have been entered correctly you will see a "ODBC Connection Tested Successfully" message on the "Result":
+{{:knowledge-base:database-migration:setup-and-troubleshooting:db2-as400:db2as400_odbc_conf_10.png?nolink|}}
+In case of the test was not successful and connection failed please check the details you have entered.
+)	Then run SQLWays Wizard and select ODBC connection.
+{{:knowledge-base:database-migration:setup-and-troubleshooting:db2-as400:db2as400_odbc_conf_11.jpg?nolink|}}
+=== Using DB2 iAccess ===
+To tune ODBC connect to AS/400 please fulfill the following steps:
+)      Install the “DB2 iAccess”.
+)      Open the “ODBC Data Source Administrator” window. If you are using the 32-bit version of Ispirer Toolkit on the 64-bit machine, you need to use the 32-bit “ODBC Data Source Administrator” (you can find it here c:\Windows\sysWOW64\odbcad32.exe).
+)      Click the "Add" button to open the “Create New Data Source” dialog for creation a new DSN.
+{{:knowledge-base:database-migration:setup-and-troubleshooting:db2-as400:db2as400_odbc_conf_12.png?nolink|}}
+)      Select the "iSeries Access ODBC Driver" from the list and click "Finish" button
+{{:knowledge-base:database-migration:setup-and-troubleshooting:db2-as400:db2as400_odbc_conf_13.png?nolink|}}
+Then setup the credentials to connect to DB2 AS/400.
+)	At the "General" tab, please enter the ODBC Connection Name and the IP address of the system.
+{{:knowledge-base:database-migration:setup-and-troubleshooting:db2-as400:db2as400_odbc_conf_14.png?nolink|}}
+)	At the "Server" tab, please select SQL Naming Convention and provide default SQL Schema or Library and click "Apply":
+{{:knowledge-base:database-migration:setup-and-troubleshooting:db2-as400:db2as400_odbc_conf_15.png?nolink|}}
+)	Run Wizard and select ODBC connect.
+{{:knowledge-base:database-migration:setup-and-troubleshooting:db2-as400:db2as400_odbc_conf_16.jpg?nolink|}}
+\\
+Tags: #2