Bookshelf Home | Contents | Index | PDF     

Siebel Database Upgrade Guide for DB2 UDB for z/OS > Basic Database Preparations for a Siebel Upgrade >

Preparing the Storage Layout of the Schema

Upgrades: All upgrades.

Environments: All environments.

Before starting the 8.0 upgrade, you have to prepare the storage control file you will use during the upgrade. The DBA can prepare the storage control file at any time before the upgrade.

The storage control file contains storage information, including bufferpools and storage groups, that is used as the basis for the storage layout of your new 8.0 Siebel database. Even if you are using a preconfigured storage layout, you must make sure that the layout is valid for your schema.

Preparing the storage control file process consists of four procedures:

NOTE:  You must validate the storage control file after you extract it and after you modify it.

There are different starting points from which you can customize your storage layout:

  • Scenario 1. Begin with a Siebel-provided storage layout template, import the template into the Siebel Database Storage Configurator (dbconf.xls), customize it, then export it as your customized layout.
  • Scenario 2. Use your current configuration from an existing database layout and merge it with one of the Siebel-provided templates. This can then be imported to the Siebel Database Storage Configurator for further manipulation.

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

To prepare the storage control file, use the Database Configuration Wizard to extract the storage layout of your database from the DB2 catalog. As part of the extraction process, you can merge the storage layout information from your existing database with information you already input into a storage template file or information in a template provided by Siebel. As an alternative, instead of extracting the storage layout of your existing database, you can use a Siebel-provided template as the storage control file.

Siebel provides the templates listed in Table 8 for the storage control file:

Table 8. Storage Control File Templates
Template
Description

storage_np.ctl

Database storage layout for a non-Unicode Siebel schema with no partitioning scheme

storage_np_u.ctl

Database storage layout for a Unicode Siebel schema with no partitioning scheme

storage_p.ctl

Database storage layout for the Siebel schema with partitioning for a set of tables on an ASCII database

storage_p_e.ctl

Database storage layout for the Siebel schema with partitioning for a set of tables on an EBCDIC database

storage_p_u.ctl

Database storage layout for the Siebel schema with partitioning for a set of tables on a Unicode database

For more information about templates for the storage control file, see Implementing Siebel Business Applications on DB2 for z/OS.

    
Siebel Database Upgrade Guide for DB2 UDB for z/OS Copyright © 2012, Oracle and/or its affiliates. All rights reserved. Legal Notices.