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 Tools
3. 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.