Configure a DB2 Database Alias (Windows) Use the following instructions to configure a DB2 Database Alias on Windows operating systems:1. Login to the computer that contains your DB2 native client.2. Expand the following menus: Start -> All Programs -> IBM DB2 -> Set-up Tools3. Launch the Configuration Assistant.

4. Expand the Selected menu.5. Select the following option: Add new database using Wizard

6. Select the following option: Manually configure a connection to a database

7. Click Next.8. Select the TCP/IP protocol.

9. Click Next.10. Provide the following information: Hostname Service Name Port Number

11. Click Next.12. Provide the following information: Your target database name An alias for your database An optional comment

13. Click Next.14. Ensure that the "Register this database for ODBC checkbox" is checked.

15. Ensure the "As system data source radio button" is selected.16. Provide a meaningful name for your System Data Source Name.17. Click Next.18. Provide the following information: The local operating system The name of the remote DB2 instance An optional comment

19. Click Next.20. Provide the following information: System name Host name Operating system Comment

21. Click Next.22. Select the appropriate authentication model for your DBMS.

23. Click Finish.