When the default satellite control database (SATCTLDB) is created, all its tables and indexes are created in the default tablespace, userspace1. For large deployments, where the DB2 control server will be managing thousands of satellites, you can change this design to allow more control over the SATCTLDB database's disk usage and performance. Disk tuning considerations for the SATCTLDB database are similar to those for any application database. For more information, refer to the Administration Guide.
The file satctldb.ddl in the sqllib\misc directory contains the DDL to define the SATCTLDB database. A copy of this file can be made and then modified to define the location and size of additional table spaces that will be used for the SATCTLDB database and to assign the SATCTLDB database's tables to these table spaces.
| Note: | When modifying this file, the table and index definitions should only be modified to add table space attributes. Do not make changes to the DDL, such as referential integrity definitions or trigger definitions, as the operation of the SATCTLDB database, the Satellite Administration Center and satellite synchronization may be adversely affected. |
The installation process on Windows NT creates the SATCTLDB database when the Control Server component is selected. The installation process on AIX does not automatically create the SATCTLDB database. If you want to use additional table spaces for your SATCTLDB database, you should create a modified version of the satctldb.ddl file, and then use it to create the SATCTLDB database that will support your environment.
For more information on issuing the commands to create SATCTLDB database using the satctldb.ddl file, see Installing the DB2 Control Server.
[ Top of Page ]