DB2 Version 9.7 for Linux, UNIX, and Windows

Updating the database manager configuration file on the server for TCP/IP communications

You must update the database manager configuration file with the service name (svcename) parameter.

To update the database manager configuration file:

1. Log on to the system as a user with System Administrative (SYSADM) authority.
2. If you are using a UNIX® server, set up the instance environment:

      . INSTHOME/sqllib/db2profile    (for Bash, Bourne or Korn shell)
      source INSTHOME/sqllib/db2cshrc (for C shell)

3. Start the DB2 command line processor (CLP).
4. Update the database manager configuration file with the Service name (svcename) parameter by entering the following commands:

        update database manager configuration using svcename
          [service_name | port_number]
        db2stop
        db2start  

   where:
   • service_name is the service name reserved in the services file
   • port_number is the corresponding port number for the service_name, or a free port number if the service_name is not reserved

   If a service name is being specified, the svcename used must match the Connection Service name specified in the services file.

   After the database manager is stopped and started again, view the database manager configuration file to ensure that these changes have taken effect. View the database manager configuration file by entering the following command:

        get database manager configuration