Implementing Siebel Business Applications on DB2 UDB for z/OS > Installing the Siebel Schema on the DB2 Host > Preparing for a Custom Installation >

Modifying Storage Control Files Using the Database Storage Configurator


When you install Siebel Business Applications, a Siebel Microsoft Excel tool, the Siebel Database Storage Configurator (dbconf.xls), is also installed. This tool helps you to configure your Siebel Schema by allowing you to import and edit the attributes of the Siebel-provided storage control file templates. You can also use this tool to configure an existing storage control file.

The Siebel Database Storage Configurator file is dbconf.xls; this file is installed in the DBSRVR_ROOT\db2390 (Windows) or $DBSRVR_ROOT/db2390 (UNIX) directory. To open dbconf.xls, you must have Microsoft Excel installed on your workstation.

After you edit a storage control file template using the Database Storage Configurator, save the file with a new name, and then direct the Database Server Configuration utility to your newly configured file when prompted to specify a storage control file during installation (see Process of Performing a Custom Installation). The output DDL is generated from the information in the (configured) storage control file that you specify.

TIP:   It is recommended that you preserve the original dbconf.xls spreadsheet and save your modified spreadsheet with a new name. Saving the spreadsheet allows you to review your current database layout while continuing to work on the storage control file; for example, because the spreadsheet allows you to sort data, you can easily identify all table spaces that belong to the same database.

To configure one of the Siebel storage control files

  1. Open dbconf.xls and select Enable Macros when prompted.

    If you are not prompted to Enable Macros, verify that your Microsoft Excel security setting is Medium, as follows:

    1. Launch Excel, and choose Tools > Macro > Security.
    2. Set the security level to medium, and then restart your computer.

      When the dbconf.xls spreadsheet opens, the Home tab is active.

  2. Import the storage control file you want to use as your template:
    1. Click Import.
    2. Go to the directory where your files with a .ctl suffix are located.
    3. Double-click the appropriate file.

      When the import process is completed, a message appears, stating that you have imported the storage control file successfully.

      Click OK.

  3. When the message, Please enter default values for your system appears, either type the values for the following parameters into the corresponding fields, or accept the default values.

    NOTE:  Replace variables that are preceded with "$" with actual values for your deployment.

    • Table Storage Group for Table
    • Index Storage for Indexes
    • 4K Buffer Pool Name
    • 16K Buffer Pool Name
    • 32K Buffer Pool Name
    • Index Buffer Pool Name
    • Database Name Prefix
    • Encoding Scheme (either ASCII or EBCDIC)
  4. Click Set.
  5. Display the template defaults by clicking the Default tab.

    NOTE:  The default values are the combined values that apply to each individual object represented by the tabs; the values can be changed within each of those tabs.

  6. Review the values, and update them as required.

    The parameters in the spreadsheet correspond to native DB2 syntax. For example, the parameters PriQty (Primary Quantity) and SecQty (Secondary Quantity) are used during the Siebel Schema creation.

    As you review the values under other tabs such as Tablespace, an empty parameter cell indicates that the cell takes the default from the value shown in the Default tab value.

    When you create a new extension table, the Database Configurator takes the Siebel default database and table space (SIEBTS00) values of the template used unless you explicitly define new values.

  7. Review the databases by clicking the Database tab.

    Be aware that the values visible on any tab also reflect the defaults for any objects at a lower level to the object for which the tab exists. Thus, if no locksize is shown for a table space under the Tablespace tab, then that table space takes the default locksize from the database object it belongs to. For example, locksize at the database object level applies to all table spaces created in a given database unless the locksize is specified explicitly in the table space object.

  8. Review the default table spaces by clicking the Tablespace tab.

    To review any partitions, do either one of the following:

    • Click twice on the Tablespace tab. (Clicking on the Tablespace tab alternates between the table spaces and table space partition worksheets.)
    • Select a row that displays a value in the Partitions column greater than zero, and then click Show TSPARTs.

      This displays the rows of corresponding partitions.

  9. Edit the values as desired, and then move off the cell to save the value.
  10. Review the default tables by clicking the Table tab.
  11. When you have updated the template, click the Home tab, and then click Export.

    The Export worksheets to storage control file screen appears.

  12. Rename the file, and save it.
  13. From the Home tab, click Clean, to make the Configurator ready for use with a different template.

    A text box appears letting you know that you have cleaned all data successfully.

Validating Your Work

You can use the Database Storage Configurator Validation button at any time to validate the syntax in the dbconf.xls spreadsheet. Wait to validate until after you have finished editing to ensure your worksheets are consistent.

NOTE:  The spreadsheet validation option is not a substitute for using the Database Server Configuration wizard to validate the storage control file after you amend it. The Validate Storage Control File option of the Database Server Configuration utility validates the new storage control file against the physical layout of the database.

To validate your dbconf.xls worksheet

  1. After updating values for any of the template defaults, click the Validate button.

    The Database Storage Configurator validates the new value and—if the value is incorrect—it appears in red. A text box also appears prompting you to review the invalid settings.

    NOTE:  If you cannot view color indicators, refer to the Accessibility Guide for Siebel Business Applications.

  2. Update any incorrect value, move off the cell, and revalidate.

    The red highlighting disappears when the validation shows that the value is correct.

Implementing Siebel Business Applications on DB2 UDB for z/OS