Implementing Siebel Business Applications on DB2 for z/OS > Configuring the Siebel Database Layout > Using the Siebel Database Storage Configurator >

Modifying a Storage Control File Using the Database Storage Configurator

To modify a storage control file using dbconf.xls, perform the following procedure.

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, and then Security.
   2. Set the security level to medium, and then restart your computer.

      When the dbconf.xls spreadsheet opens, the Home tab is active. Click the Functions tab to select one of the functions available in dbconf.xls. Click the Structures to display information about database objects.

2. Import the storage control file you want to use as your template:
   1. With the Home tab active, 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.

   4. 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 the $ symbol with actual values for your deployment.

   • Table Storage Group for Table
   • Index Storage for Indexes
   • 4K Buffer Pool Name
   • 8K Buffer Pool Name
   • 16K Buffer Pool Name
   • 32K Buffer Pool Name
   • Index Buffer Pool Name
   • Database Name Prefix
   • Encoding Scheme (ASCII or EBCDIC)
4. Click Set.
5. You are prompted to indicate whether or not you want to import row lengths. Select No.

   You need to import row lengths if you intend to do either of the following:

   • Convert your database from a non-Unicode to a Unicode encoding scheme
   • Perform space calculations using dbconf.xls.
6. Select the Functions tab, then display the template defaults by clicking the Defaults tab.

   The default values are the values that apply to an individual object in the storage control file if no other value is specified. You can change the default value for an individual object by navigating to the relevant tab (select the Structures tab, then the relevant object type tab) and changing the information displayed.

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

   When you review the values under the object type tabs, for example, Tablespace, an empty parameter cell indicates that the cell takes the default value for the object.

7. Review the default 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.

8. Review the databases by clicking Structures, and then Database.

   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.

9. Review the table spaces by clicking Structures, and then Tablespace.

   To review any partitions, 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.

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

    The Export worksheets to storage control file screen appears.

13. Rename the storage control file, for example, my_storage_p.ctl, and save it. A message is displayed saying that the file will be validated.
14. Click OK.

    When the validation process is completed, a message is displayed if the file contains any invalid values that you need to review. The following is an example of the type of message that might be displayed:

    Please review index partitions which are marked in red

15. Click OK.

    The errors in the file are displayed, highlighted in red.

16. Make a note of the object that is generating the errors. The relevant object type tab and the object are highlighted. Click OK.
17. Review and correct the object values that generated the validation errors. For example, if the values specified for a partitioning index partition are incorrect, do the following:
    1. Select Structures, and then Partitioning Index.
    2. Select the relevant index, then click the Show Index Parts button.

       The index partitions are displayed and the cells that contain invalid values are highlighted.

    3. Amend the invalid values, then export the file again.

       You cannot export the file until the validation process completes without error.

18. When you have exported the file, click Home, and then Clean, to make the Database Storage 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 Validate 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 Configuration Wizard to validate the storage control file after you amend it. The Validate Storage File option of the Database Configuration Wizard 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; if the value is incorrect, it is highlighted in red. A text box also appears prompting you to review the invalid settings.

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

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