Siebel Database Upgrade Guide for DB2 for z/OS > Creating the Siebel Staging Database >

Required Tasks before Creating the Staging Database


Upgrades: All upgrades.

Environments: All environments.

Before you create the staging database, complete the following tasks:

  1. Allocate an empty tableowner for the staging database.
  2. Do the following:
    1. Make sure you have a valid storage control file for the database to be upgraded. This contains the storage definitions of the existing database and is used to generate the DDL to build the staging database schema.
    2. Name this storage control file storage_target_extonly.ctl.

      If you do not have a valid storage control file, create one by running the Database Configuration Wizard and selecting the Extract from Catalog option. Specify database details for your existing Siebel database (the database to be upgraded). For further information on this task, see Implementing Siebel Business Applications on DB2 for z/OS.

      The Extract from Catalog option extracts the storage layout of the database you specify from the DB2 catalog and creates a new storage control file that contains a copy of the storage definitions of the database.

  3. Make sure the logical repository definitions and the physical schema definitions of the database to be upgraded match by running the Database Configuration Wizard, and specifying the following options:
    • Siebel Database Operation: Run Database Utilities
    • Database Utility Selection: Synchronize Schema Definition
    • Repository Synchronization Mechanism: Generate DDL into Files
    • Storage Control File: Specify the file you extracted in Step a above

      NOTE:  It is recommended that you drop EIM tables before synchronizing the Siebel logical and physical schema to ensure that the synchronization process does not fail when processing EIM tables.

      When the synchronize process completes, if the logical and physical schema database definitions match, no files are generated from the Synchronize Schema Definition process and no further action is required.

      If the logical and physical schema database definitions do not match, a message is displayed stating that files have been generated. Click Yes to exit from the Wizard, then do the following:

    1. Navigate to the directory you assigned as the Output Directory.
    2. Transfer the schema.sql file to the z/OS host and ask your DBA to apply the DDL contained in the file.

      For detailed information on running the Synchronize Schema Definition process, see Implementing Siebel Business Applications on DB2 for z/OS.

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