Bookshelf Home | Contents | Index | PDF |
Implementing Siebel Business Applications on DB2 for z/OS > Configuring the Siebel Database Layout > About Storage Control File TemplatesThe storage control file is unique to the DB2 for z/OS platform for Siebel Business Applications. The storage control file contains storage information (for example, partitioning indexes, table spaces, and storage groups) that is used as the basis for the storage layout of your Siebel database. Even if you are using a preconfigured storage layout, make sure that the layout is valid for your Siebel Schema. Starting with release 7.7, the Siebel database schema structure implements a 1:1:1 model (one table in each table space, and one table space in each database). This layout reduces logging, removes concurrency issues, and allows for more databases to be used to achieve high database parallelism. While this is the most appropriate schema structure to avoid database descriptor (DBD) locking and logging, you can choose to regroup tables in table spaces and table spaces in databases. However, if you do implement a structure other than the 1:1:1 model (for example, a 1:M:1 schema layout), ensure that you carefully monitor the impact of doing so in your environment. If you notice a decrease in the performance of Siebel Business Applications, this could be due to lock contention occurring as a result of SQL executed by Siebel Business Applications or Siebel utilities. In this case, you might have to make adjustments to the schema layout. The Siebel application installation process installs five storage control file templates in the
The layouts of the storage control file templates are generic; your DBA must customize them to suit the needs of your enterprise, for example, to change the default space allocation for Siebel objects, seed data, and views. Although Siebel-provided templates might be sufficient for your development environment without any changes, it is recommended that your DBA reviews and modifies the database storage layout to best fit the needs of your deployment in a production environment. The storage control file templates are the starting point for your customization process. Before you select a Siebel storage control file template, you need to understand how Siebel objects are grouped and the object naming conventions used. |
Implementing Siebel Business Applications on DB2 for z/OS | Copyright © 2016, Oracle and/or its affiliates. All rights reserved. Legal Notices. | |