Implementing Siebel Business Applications on DB2 UDB for z/OS > Configuring the Database Layout > About Creating or Modifying the Database Layout >

Modifying the Storage Control File


You can adjust the storage control file using either of the following methods:

  • Open the storage control file with a text editor program and edit it directly to adjust object definitions or options.

    This approach is useful for making minor adjustments to the database layout but should only be used if you have a thorough understanding of the storage control file structure. Otherwise, you could introduce errors into the file and affect the operation of your Siebel applications.

  • Use the Siebel Database Storage Configurator (dbconf.xls).

    This is a Microsoft Excel macro tool that allows you to import and edit attributes from one of the Siebel-provided storage control file templates. After you customize the template and save the resulting storage control file with a new name, the storage control file contains the actual names for the DB2 objects.

    TIP:   Append the name of your new storage control file with a suffix; for example, if you use storage_p.ctl for your input, name the resulting file storage_p_suffix.ctl, where you replace suffix with an identifiable character string.

    The dbconf.xls file is installed in the DBSRVR_ROOT\db2390 (Windows) or $DBSRVR_ROOT/db2390 (UNIX) subdirectory. To open dbconf.xls, you must have Microsoft Excel installed on your workstation. For further information, see Modifying Storage Control Files Using the Database Storage Configurator.

    NOTE:  If your installation is UNIX, you must transfer dbconf.xls and the storage control file that you want to configure to your Microsoft Windows environment. Use BINARY FTP to transfer the dbconf.xls file.

Implementing Siebel Business Applications on DB2 UDB for z/OS