Bookshelf Home | Contents | Index | PDF     

Implementing Siebel eBusiness Applications on DB2 UDB for z/OS and OS/390 > Siebel Schema Installation on the DB2 Host > Preparing the Database Layout >

Configuring a Siebel Storage Control File

The following procedure uses the template storage_p.ctl as an example to illustrate general use of the Database Storage Configurator.

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.

    NOTE:  If you are not prompted to enable macros, verify that your Microsoft Excel security setting is Medium. Launch Excel, choose Tools > Macro > Security. Verify that Security Level is set to Medium. If necessary, reset the security level to medium, then restart your computer.

    When the 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 complete, 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.
  6. Review the values and update them as required.

    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.

    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 from the object for which the tab exists. So, if no locksize is shown on for a table space under the Tablespace tab, that means that it takes the default from the database object it belongs to; for example, locksize on 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 Partition column greater than zero, then click Show TSPARTs.

      This displays the rows of corresponding partitions.

  9. Edit the values as desired, and then step 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 to a location that is easy for you to find during installation.
  13. To make the Configurator ready for use with a different template, from the Home tab, click Clean.

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

Validating Your Work

You can use the Validation button at any time to validate the syntax in the spreadsheet. Your worksheets will be more consistent if you wait to validate until after you have finished editing.

To validate your worksheet

  1. Click the Validate button.

    The 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 in red text.)

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

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

Partitioning Tables and Indexes

The following two procedures demonstrate how to use the Database Storage Configurator to partition tables after you have worked out a partitioning scheme. For guidelines about partitioning, see Understanding Siebel Partitioning.

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

Decreasing the Number of Partitions

This procedure describes how to decrease the number of partitions in a table space.

To decrease the number of partitions

  1. Launch the Database Storage Configurator as described in Configuring a Siebel Storage Control File and import the .ctl file you want to amend.
  2. Click the Tablespace tab on the Database Storage Configurator.
  3. Locate the row with the Tablespace tab in it that you want to change, and change the value in the Partitions column to reflect the number of new partitions you want to create.
  4. Save the new value by stepping off the cell.
  5. Click Show TSPARTs.
    • If a message box appears, prompting you that there are additional table space partitions for this table, and requesting that you review and delete them, do so now.
    • If everything is in order, you receive a message indicating that the operation was successful.
  6. Click the Partitioning Index tab and locate the partitioning index associated with this table space.
  7. Update the number of partitions to match the number of table space partitions you entered previously, then step off the cell to save the value.
  8. Click Show Index Parts.
    • If a message box appears, prompting you that there are additional partitioning indexes for this table space, and requesting that you review and delete them, do so now. Proceed to Step 9.
    • If everything is in order, you receive a message indicating that the operation was successful.
  9. Review the values in the LimitKey column and update them appropriately.

    NOTE:  When using Excel, you must type the first quote as two single quotes. Excel saves it as a single quote when you step off the cell. If you do not enter two single quotes, Excel deletes it entirely when you step off the cell.

  10. Make any other edits needed to the template you are using and follow the steps under Configuring a Siebel Storage Control File to verify and save your changes to a location that will be easy to find when you or someone else installs the Siebel Schema.
Increasing the Number of Partitions

Usually, the partitioning is done for a table. You must adjust the related table space and partitioning index. The following procedure describes how to increase the number of partitions for a table and index in a given table space.

To increase the number of partitions

  1. Launch the Database Storage Configurator as described earlier in this chapter under Configuring a Siebel Storage Control File and select the Table tab.
  2. Locate the name of the partitioned table space for which you want to increase the number of partitions.
  3. Click the Tablespace tab and search for the corresponding table space.
  4. Increase the value in the Partitions column for that table space as appropriate and step off the cell to save it, but keep your cursor in the same row. (If you do not keep your cursor in the same row, you cannot get to the table space partitions by clicking the Show TSPARTs button.)
  5. Click Show TSPARTs.

    When you increase the value in the Partitions column, you receive a message indicating that the partitions were added successfully.

  6. Click the Partitioning Index tab and locate the partitioning index associated with the table you are operating on.
  7. Increase the number of partitions to match the value you previously entered for the associated table space, and step off the cell to save the value, but keep your cursor on the same row.
  8. Click Show Index Parts.

    A text box appears prompting you that the extra partitions were created successfully.

  9. Review the LimitKey values and update them as appropriate.

    NOTE:  When using Excel, you must type the first quote as two single quotes. Excel saves it as a single quote when you step off the cell. If you do not enter two single quotes, Excel deletes it entirely when you step off the cell.

  10. Make any other edits needed to the template you are using. Then follow the steps under Configuring a Siebel Storage Control File to verify and save your changes to a location that will be easy to find when you or someone else installs the Siebel Schema.

Working with CLOBs

Your Siebel application is delivered with the objects needed to create character large objects (CLOBs), even if you did not choose CLOBs as an option. These objects are used to create CLOBs only at the table level to prevent excessive processing overhead.

To activate a CLOB

  1. Launch the Database Storage Configurator as described in Configuring a Siebel Storage Control File and select the Table tab.
  2. Review the contents of the CLOB column.
  3. To activate a particular CLOB, type Yes in the appropriate row in the CLOB column, then save the value by stepping off the cell.

    NOTE:  The auxiliary table space name displays a table name that is used as a pointer to a real auxiliary table space. The parameters displayed under this tab are the only parameters allowed to change for the auxiliary object.

    
Implementing Siebel eBusiness Applications on DB2 UDB for z/OS and OS/390