Implementing Siebel Business Applications on DB2 UDB for z/OS > Customizing a Development Environment >

About Creating Custom Extensions to the Siebel Schema

There are several different possible scenarios for creating Siebel Schema custom extensions:

• Creating a small extension column, so the table fits into its existing table space
• Creating a large extension column, so the table has to be redefined to a larger page size and therefore a larger table space
• Creating an extension table

CAUTION:  If a LONG VARCHAR column is defined for a table, attempting to add an extension column to the table causes an error. This is because a LONG VARCHAR column uses all the space in a table space that is not used by the non-LONG VARCHAR columns, leaving no space available for an extension column. In this case, use an extension table instead. For further information, see How Siebel Implements LONG Columns on DB2 for z/OS.

The process of creating a small extension column is the same on z/OS as on other platforms and is documented in Using Siebel Tools.

To create a large extension column or an extension table, you must specify a 16 KB or 32 KB table space:

• If you are developing on DB2 for Windows or UNIX, you must enter a 16 KB or 32 KB table space in the Apply Schema screen. (See Step 4.)
• If you are developing on DB2 for z/OS, you must edit the storage control file to specify the database and table space in which the new extension column or table is to reside.

NOTE:  Creating tables with Identity type columns or extension columns of Identity type is not supported.

For information on estimating storage needs, see Preparing for Implementation on the DB2 Host.