DB2 10.5 for Linux, UNIX, and Windows

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

This task is part of the main task of configuring TCP/IP communications for a DB2® instance.

About this task

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

Procedure

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 operating system, 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