%META:TOPICPARENT{name="PreinstallDB2LiteWin32"}%
==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.

  <img src="%ATTACHURLPATH%/config_assistant.png"/>


4. Expand the Selected menu.

5. Select the following option:  Add new database using Wizard

  <img src="%ATTACHURLPATH%/config_selected_menu.png"/>

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

  <img src="%ATTACHURLPATH%/manually_config_db.png"/>

7. Click Next.

8. Select the TCP/IP protocol.

  <img src="%ATTACHURLPATH%/manually_config_tcp.png"/>

9. Click Next.

10. Provide the following information:

* Hostname
* Service Name
* Port Number

  <img src="%ATTACHURLPATH%/config_tcp_comm_params.png"/>

11. Click Next.

12. Provide the following information:

* Your target database name
* An alias for your database
* An optional comment

  <img src="%ATTACHURLPATH%/config_db_info.png"/>

13. Click Next.

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

  <img src="%ATTACHURLPATH%/db2_register_odbc.png"/>


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

  <img src="%ATTACHURLPATH%/node_options.png"/>

19. Click Next.

20. Provide the following information:

* System name
* Host name
* Operating system
* Comment

  <img src="%ATTACHURLPATH%/system_options.png"/>

21. Click Next.

22. Select the appropriate authentication model for your DBMS.

  <img src="%ATTACHURLPATH%/security_options.png"/>

23. Click Finish.