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

Preparing the Storage Layout of the Schema

Upgrades: All upgrades.

Environments: Development environment only.

Before starting the 7.8 upgrade, you must 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 7.8 Siebel database. Even if you are using a preconfigured storage layout, you must make sure that the layout is valid for your schema.

NOTE:  Release 7.7 includes a new schema structure. For more information on this structure, see Planning Your Upgrade.

Preparing the storage control file consists of four procedures:

• Modifying the Storage Control File
• Extracting the Storage Control File
• Validating the Extracted Storage Control File
• Reviewing the Storage Control File

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 Siebel Database Storage Configurator for further manipulation.

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

To prepare the storage control file, use the Database Server Configuration Wizard to extract the storage layout of your source 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 Systems provides three templates for the storage control file:

• storage_np.ctl. Contains no partitioning scheme
• storage_p.ctl. Contains partitioning scheme for a set of tables on an ASCII database
• storage_p_e.ctl. Contains partitioning scheme for a set of tables on an EBCDIC database

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

CAUTION:  The storage layout for partitioned tables ships with a default code page of ASCII. If you are upgrading an EBCDIC database, you must use the EBCDIC storage control file storage_p_e.ctl.