Bookshelf Home | Contents | Index | Search | PDF

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

About Schema Extension Tasks

---

The following tasks must be performed to extend the Siebel schema:

Check out and lock the project to which the table being extended belongs. In most cases this is Newtable.

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 Siebel Tools Reference.

Update the logical schema definition in the development environment using Siebel Tools. This works as on other platforms and is documented in Siebel Tools Reference and Developing and Deploying Siebel eBusiness Applications.

NOTE:  Make sure that you have selected the check box on the Database tab of the Development Tools Options dialog under the View menu. This validates the objects' compliance with DB2 UDB for OS/390 and z/OS naming and sizing conventions.

Apply the physical schema extensions to the development database:
If developing on DB2 UDB for Windows or UNIX, follow the procedures inApplying Schema Extensions to the Development Database.
If developing on DB2 UDB for OS/390 and z/OS, follow the procedures in Migrating Customizations from Development to the Target Database.

In some companies, direct database extension is not allowed. Siebel Tools does not allow the Apply button to be disabled. The Apply process will fail if developers do not have proper 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 databases, 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.

Update and test configuration changes that apply to the extensions.

See Siebel Tools Reference, Developing and Deploying Siebel eBusiness Applications, Applications Administration Guide, and other documentation on the Siebel Bookshelf CD-ROM.

Bookshelf Home | Contents | Index | Search | PDF