Application Building Guide

Enabling Communications on the Server

This section explains how to connect to DB2 Universal Database servers.

Before you begin installing, cataloging, and binding the sample database, you should ensure that the server is operational and configured to support the protocol being cataloged. Do the following on the server:

1. Ensure that the db2comm environment variable is set. For example, if TCP/IP is being used, enter:

      db2set DB2COMM=tcpip
   

   and ensure that the protocol for TCP/IP support is configured.

   Refer to your platform's Quick Beginnings book for instructions on adding the TCP/IP settings to the Services file.

2. Start the database instance by entering:

      db2start
   

The binding of the utilities to the sample database must be done from the client. For more information, see Binding.

Windows NT and Windows 2000

In a production system for DB2 for Windows NT or DB2 for Windows 2000, you have to start the database instance as a service. The steps are as follows:

• If using communications protocols, ensure that the db2comm environment variable is set in the System Environment Variables section of the Windows NT or Windows 2000 control panel.
• Start the security service. This can be done automatically (see the note below), or you can start this service manually using the following command:

     NET START DB2NTSECSERVER
  

• Start the instance by entering:

     db2start
  

Starting the Security Service automatically. Normally the only time you would want to set the security service to start automatically is if the workstation is acting as a DB2 client connecting to a server that is configured for Client Authentication. To have the security service start automatically, do the following:

Windows NT

1. Click on the "Start" button.
2. Click on "Settings".
3. Click on "Control Panel".
4. In the Control Panel, click on "Services".
5. In the Services window, highlight "DB2 Security Server".
6. If it does not have the settings "Started" and "Automatic" listed, click on "Startup".
7. Click on "Automatic".
8. Click on "OK".
9. Reboot your machine to have the settings take effect.

Windows 2000

1. Click on the "Start" button.
2. Click on "Settings".
3. Click on "Control Panel".
4. Click on "Administrative Tools".
5. Click on "Services".
6. In the Services window, highlight "DB2 Security Server".
7. If it does not have the settings "Started" and "Automatic" listed, click on "Action" from the top menu.
8. Click on "Properties".
9. Make sure you are in the "General" tab.
10. Choose "Automatic" from the 'Startup Type' drop-down menu.
11. Click on "OK".
12. Reboot your machine to have the settings take effect.