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

Performing a Standard Installation


This procedure describes how to perform a standard installation. You can use the standard installation option as your sole installation procedure, or you can perform the standard installation as a first step of a custom installation and then customize your deployment after you have completed the standard installation. To perform a custom installation, see Performing a Custom Installation.

The standard installation provides six schema layout options. You must select one of the Siebel Systems-provided templates listed below to implement the appropriate layout for your database schema.

Schema Layout
Template Name
Description
One table per table space with partitioning for ASCII
storage_p_1to1.ctl
Contains a partitioning scheme for a set of tables; every nonpartitioned table resides in its own segmented table space.
Multiple tables per table space with partitioning for ASCII
storage_p_group.ctl
Contains a partitioning scheme for a set of tables; nonpartitioned tables are logically grouped by table space.
One table per table space with partitioning for EBCDIC
storage_p_1to1_e.ctl
Contains a partitioning scheme for a set of tables; every nonpartitioned table resides in its own segmented table space.
Multiple tables per table space with partitioning for EBCDIC
storage_p_group_e.ctl
Contains a partitioning scheme for a set of tables; nonpartitioned tables are logically grouped by table space.
One table per table space
storage_np_1to1.ctl
Contains no partitioning scheme; provides tables in a configuration where there is one nonpartitioned table in each table space.
Multiple tables per table space

storage_np_group.ctl

Contains no partitioning scheme; provides tables logically grouped by one table space.

See About the Siebel Storage Control File Templates for descriptions of the templates.

NOTE:  If you choose the Siebel partitioned layout, a select subset of Siebel tables are defined as partitioned with predefined partitioning indexes. For a discussion of partitioned tables and partitioning indexes, see About Siebel Partitioning.

During the standard installation process, you indicate how you want to execute DDL that was created based on your layout choices. You can execute DDL directly against the database by choosing Run DDL Automatically. Alternatively, by choosing Generate DDL Into Files, you can assign DDL to an output file for later transfer to the DB2 host (using FTP or another file transport program) where the DBA applies the DDL using customary tools.


 Implementing Siebel eBusiness Applications on DB2 UDB for OS/390 and z/OS 
 Published: 18 April 2003