Implementing Siebel Business Applications on DB2 UDB for z/OS > Customizing a Development Environment > About Creating Custom Extensions to the Siebel Schema >

Process of Extending the Siebel Schema

To extend the Siebel Schema, perform the following tasks:

1. Using Siebel Tools, check out and lock the project to which the table being extended belongs. In most cases, this is Table Common.

   If you want to import data into the new column using Enterprise Integration Manager (EIM), you must check out the project to which the appropriate interface table belongs. For more information, see the topics on EIM in Using Siebel Tools.

2. Update the logical schema definition in the development environment using Siebel Tools. This process is the same on z/OS as on other platforms and is documented in Using Siebel Tools and Developing and Deploying Siebel Business Applications.

   NOTE:  Make sure that you select the check box on the Database tab of the Development Tools Options dialog under the View menu. This option validates the object's compliance with DB2 for z/OS sizing conventions.

3. Apply the physical schema extensions to the development database:
   • If you are developing on DB2 for Windows or UNIX, follow the procedures in Applying Schema Extensions to the Development Database.
   • If you are developing on DB2 for z/OS, follow the procedures in Migrating Customizations from Development to the Target Database.

     Some companies do not allow direct database extension. Siebel Tools does not allow the Apply/ DDL button to be disabled but the Apply process fails if developers do not have appropriate database privileges (such as CREATEDBA and DBADM). For information about the Apply process, see Applying Schema Changes to the Target Database.

     If you do not want developers to extend tables, you can control this using database privileges. In this case, developers follow the procedures in Migrating Customizations from Development to the Target Database to apply schema extensions to their development databases.

4. Update and test configuration changes that apply to the extensions.

   See Using Siebel Tools, Developing and Deploying Siebel Business Applications, and Siebel Applications Administration Guide.