Implementing Siebel Business Applications on DB2 for z/OS > Customizing a Development Environment > Process of Applying Schema Extensions to the Target Database >

Preparing the Target Database

This topic describes how to prepare a Siebel production database before Siebel Schema extensions are applied.

This task is a step in Process of Applying Schema Extensions to the Target Database.

Complete the following actions before migrating the changes to the target database:

• Prepare the storage control file (for example, my_storage_file.ctl).

  If you have created any new extension tables, edit the storage control file to specify the database and table spaces where the new extension tables are to reside. For information on this task, see Amending the Storage Control File for New Schema Objects.

• Ask all mobile users to synchronize.
• Make sure all connected clients are disconnected from the Siebel database.
• When all mobile user transactions have been merged and routed, stop the Siebel Server.
• Perform a full backup of the database.

  NOTE:  If you are changing the data type or length of custom extension columns that already contain data in the target database, export that data before making the schema changes. After making the changes, import the data back into the target database.