Siebel Database Upgrade Guide for DB2 UDB for z/OS > Basic Database Preparations for a Siebel Upgrade > Preparing the Storage Layout of the Schema >

Modifying the Storage Control File

There are three methods by which you can configure storage space:

• Method 1. This method consists of performing a standard Siebel database installation by running the Database Configuration Wizard, choosing the Generate DDL into a File installation option, and specifying as input one of the Siebel storage control file templates. This process generates the following:
  • A storage control file, based on the Siebel template file you selected, that incorporates the configuration information you entered when you ran the Database Configuration Wizard. This file is generated in the dbsrvr\DB2390 (Windows) or dbsrvr/DB2390 (UNIX) directory
  • A schema.sql file that is applied on the z/OS host to create the Siebel schema. The schema.sql file is based on the customized storage control file generated by the database install

    Using these files, you can then configure storage space in any of the following ways:

  • Amend the storage control file generated during the database install in the dbsrvr\DB2390 (Windows) or dbsrvr/DB2390 (UNIX) directory (see also Method 2).
  • Apply the schema.sql file generated by the database install on the DB2 host to create the Siebel schema, then amend the schema using native DB2 tools. Extract the storage control file from the DB2 catalog; the file will include the changes you have made.

    NOTE:  You access the extract utility Siebel provides through the Database Configuration Wizard. This utility allows you to extract information from the DB2 catalog. You can use this extract utility any time you want to create a new storage control file, based on the DB2 catalog.

  • Amend the schema.sql file generated by the database install directly, apply it on the DB2 host to create the schema, and then extract the storage control file, which will include the changes you made.

    For information on installing the Siebel database and extracting storage control files, see Implementing Siebel Business Applications on DB2 for z/OS.

• Method 2. This method consists of manipulating the storage control file (storage.ctl) directly by opening it with a text editor program. This method can be used if you understand the file structure.

  You can use this method to amend one of the Siebel-supplied storage control files or to amend a storage control file that you have extracted from another Siebel schema.

• Method 3. This method consists of using the Siebel Database Storage Configurator tool. The Siebel Database Storage Configurator tool is a Microsoft Excel macro (dbconf.xls) that is installed in the dbsrvr\db2390 (Windows) or dbsrvr/db2390 (UNIX) subdirectory of your installation directory. This tool allows you to import a storage control file, amend it, validate the syntax of your changes, and then save it.

  UNIX customers must transfer dbconf.xls and the .ctl files to their Microsoft Windows environment. Use BINARY FTP transfer for the dbconf.xls file.

  For information on using the Siebel Database Storage Configurator, see Implementing Siebel Business Applications on DB2 for z/OS.

NOTE:  Validate the storage control file after you modify it. See Validating the Extracted Storage Control File for further information.