Implementing Siebel eBusiness Applications on DB2 UDB for z/OS and OS/390 > Preparing for Implementation on the DB2 Host >

Estimating the Number of Database Objects You Need

Siebel Systems ships over 3,000 tables, table spaces and databases, and over 15,000 indexes for Siebel eBusiness Applications and over 4,000 tables and 21,000 indexes for Siebel Industry Applications.

The number of objects created in the Siebel Schema depends on which Siebel product line you purchase. This consequently determines how much space you must allocate. It is up to you to determine which of the objects shipped might actually be required for your deployment, based on your business needs.

CAUTION:  You must not drop unused tables; doing so causes Siebel Systems to discontinue technical support of your deployment. If you need to drop unused, non-unique Siebel indexes on the z/Series, contact Siebel Technical Support for assistance.

Siebel eBusiness Applications ships all table space and index schema definitions with the DEFINE NO option as the default. The DB2 DEFINE option specifies if the underlying data sets for a table space or index are created physically. Because the Siebel default is DEFINE NO, this means that no physical data sets are created until data is actually inserted into the table space.

NOTE:  DEFINE NO is only applicable to DB2-managed (STOGROUP) data sets and is ignored for user-managed (VCAT) data sets and for LOB table spaces.