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

Process of Extending the Siebel Schema

To extend the Siebel Schema, perform the following tasks:

1. 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 sections on EIM in the Using Siebel Tools guide.

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 the Using Siebel Tools and Developing and Deploying Siebel Business Applications guides.

   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 objects' compliance with DB2 for z/OS and 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 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 the Using Siebel Tools and the Developing and Deploying Siebel Business Applications guides, the Applications Administration Guide, and other documentation on the Siebel Bookshelf CD-ROM.