DB2 Version 9.7 for Linux, UNIX, and Windows

Setting up a working collective to distribute commands to ESE workstations (AIX)

This can be useful when installing or administrating a partitioned database system on AIX, to enable you to quickly execute the same commands on all the computers in your environment with less opportunity for error.

You must know the hostname of each computer that you want to include in the working collective.

You must be logged on to the Control workstation as a user with root authority.

Have a file that lists the hostnames for all of the workstations that will participate in your partitioned database system. To set up the working collective to distribute commands to this list of workstations:

1. Create a file called eeelist.txt that will list the hostnames for all of the workstations that will participate in the working collective.

   For example, assume that you wanted to create a working collective with two workstations called workstation1 and workstation2. The contents of eeelist.txt would be:

      workstation1
      workstation2

2. Update the working collective environment variable. To update this list, enter the following command:

      export WCOLL=path/eeelist.txt

   where path is the location where eeelist.txt was created, and eeelist.txt is the name of the file that you created that lists the workstations in the working collective.
3. Verify that the names in the working collective are indeed the workstations that you want, by entering the following command:

      dsh -q

   You will receive output similar to the following:

      Working collective file /eeelist.txt:
      workstation1
      workstation2
      Fanout: 64