Administering Satellites Guide and Reference

Installing the DB2 Control Server

The DB2 control server is installed as an optional component of DB2 Universal Database on Windows NT and AIX during a custom installation. Select the Control Server component to install the DB2 control server. For basic component selection and installation information, refer to the appropriate DB2 Quick Beginnings book.

Setting up the DB2 Control Server on AIX

The SATCTLDB database is not automatically created during the DB2 control server installation on AIX. You should create a modified version of the satctldb.ddl file, and use it to create the SATCTLDB database that will support your environment. The file satctldb.ddl can be found in the sqllib\misc directory.

To setup the DB2 control server:

1. Create the DB2CTLSV instance.
2. Run the satctldb.ddl file to create the SATCTLDB database.

Creating the DB2CTLSV Instance

To create the DB2CTLSV instance:

1. Log on as user with root authority.
2. Change to the directory where the DB2 CD-ROM is mounted by entering the following command:

      cd /cdrom
   

   where /cdrom represents the mount point of the CD-ROM drive.

3. Change to the /cdrom/db2/aix directory where the install image for the DB2 product that you want to install is located.
4. Enter the ./db2setup command to start the DB2 installation program. The DB2 Installer window opens.
5. Use the Tab key to select the Create option. The Create DB2 Services window opens.
6. Select Create a DB2 Instance. The DB2 Instance window opens.
7. Rename the user name field with db2ctlsv. Use the default User ID and password. Change the home directory to /home/db2ctlsv to match the instance. Select OK. The Fenced User windows opens.
8. Select OK to accept the defaults. The Create DB2 Services window opens.
9. Select OK. The Summary Report window opens.
10. Select Continue.

Creating the SATCTLDB Database

To create the SATCTLDB database, perform the following steps:

1. Log in as db2ctlsv.
2. Ensure that the database server has been started; the db2start command has been issued.
3. If you do not want the default SATCTLDB database created, copy and edit the satctldb.ddl file to satisfy your requirements. For more information on customizing the DDL file, refer to the following URL: www.software.ibm.com/data/db2/library/satellite.
4. Enter the following command, from the sqllib/misc directory:

   db2 -tf prdctldb.ddl -z $HOME/prdctldb.log
   

   where prdctldb.ddl represents the modified version of the DDL file and is located in the sqllib/misc directory.

5. Check the prdctldb.log file for errors that may have been encountered during the creation of the SATCTLDB database.

Setting up the DB2 Control Server on Windows NT

For large deployments where thousands of DB2 satellites will be managed by the DB2 control server, you should use your own design, rather than the default, to allow more control over the SATCTLDB database's disk usage and performance. If you want to use your own design, you must first drop the default database and re-create the SATCTLDB database based on your customized DDL file.

To customize your design, perform the following steps:

1. Make a copy of the satctldb.ddl file and customize it to meet your needs. For the purposes of this example, prdctldb.ddl is used as the filename for the customized DDL file. For more information on customizing the DDL file, refer to the following URL: www.software.ibm.com/data/db2/library/satellite.
2. Open a command window by clicking on Start, then selecting Programs -> DB2 for Windows NT -> Command Window.
3. In the Command Window, ensure that the DB2INSTANCE environment variable is set to DB2CTLSV. To check the DB2INSTANCE environment variable enter the set db2instance command. The value returned must be DB2INSTANCE=DB2CTLSV. If the environment variable is not set to DB2CTLSV, enter the SET DB2INSTANCE=DB2CTLSV command to change its setting.
4. Drop the default SATCTLDB database that was created during the installation by entering the following command:

   DROP DATABASE SATCTLDB
   

5. Change to the directory where you have stored your customized prdctldb.ddl file.
6. Enter the following command:

   db2 -tf prdctldb.ddl  -z prdctldb.log
   

   where prdctldb.ddl represents your customized DDL file.

   Check the prdctldb.log file for errors that may have been encountered during the creation of the SATCTLDB database.

Other Considerations

When the default or customized version of SATCTLDB database is created, it is not backed up, nor is it enabled for forward recovery. For more information on defining a recovery strategy for this critical database, see the Recovering the DB2 Control Server and Satellite Control Database.

You can now proceed to create groups, satellites, and batches using the Satellite Administration Center.

[ Top of Page ]