Admin: DB2 Configuration

This section describes how to create and configure DB2 Data Source Name (DSN). Please follow the steps below. Please note that you may skip steps 1 – 4 if you have already installed the ODBC driver.

1. In a web browser, navigate to http://www01.ibm.com/support/docview.wss?uid=swg21385217 to download the driver.

2. In the download load page, click IBM Data Server Runtime Client.

3. In the download folder, double click v10.5fp5_ntx64_rtcl.exe.

4. In the DB2 Setup Window, click Next and follow the required steps to install the driver

5. Once you have successfully installed the driver, go to Control Panel\All Control Panel Items\Administrative Tools and click Data Sources (ODBC).

6. In the ODBC Data Source Administrator Window, click the System DSN tab.

7. Click the Add… button to create a new Data Source.

8. Find and select IBM DB2 ODBC DRIVER – BD2COPY1 and click Finish.

9. Enter the Data source name. Click Add.

   

10. In the Data Source Tab, enter the following details:

    1. User ID: the database username.

    2. Password: the database password.

    3. Save password: this option must be selected.

       

11. Click the TCP/IP tab. Enter the following details:

    1. Database name: the name of the DB2 database.

    2. Database alias: the DB2 database’s alias.

    3. Host name: the host server (IP address or server name).

    4. Port number: the server port number. Only numerical values are supported. The default server port is 50000.

       

12. Click the OK button to create the DSN.

13. Once completed, launch Server Workbench and login.

14. In the Install Client at Data warehouse pane, select AWS Redshift as the database provider.

15. Enter the Server name. This can be either the DNS (Domain Name System) or an IP address of the server.

16. Enter the Database provider.

17. Enter the Data Source Name.

18. Enter the Database schema.

19. Check the End User License Agreement checkbox and then click Next.