DB2 Version 9.7 for Linux, UNIX, and Windows
Installing DB2 Servers > Additional Linux and UNIX requirements > Additional partitioned database environment pre-installation tasks (Linux and UNIX) >

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

In a partitioned database environment on AIX®, you can set up a working collective to distribute commands to the set of workstations that participate in your partitioned database system. Commands can be distributed to the workstations by the dsh command.

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

[ Top of Page | Previous Page | Next Page | Contents ]