Siebel Installation Guide for UNIX: Servers, Mobile Web Clients, Tools > Configuring the RDBMS > Configuring IBM DB2 UDB for Siebel Applications >

Guidelines for Creating DB2 UDB Database Objects

To help you automate creation of the Siebel Database schema, Siebel Systems provides sample scripts (CrBlankDB2UDBSiebelDEMO.sql and CrBlankDB2UDBSiebelDEMOPostCrDB.sql), located in the $SIEBEL_ROOT/dbsrvr/DB2UDB directory. Use these scripts as a reference to create scripts based on your deployment's requirements for creating database objects for the Siebel schema.

Before using these scripts, make sure you read the file CrBlankDB2UDBSiebelDEMOReadMe.txt. See also Overview of Database Configuration.

Use a small, nonproduction environment for testing purposes.

After you install the Siebel Database Server files on the Siebel Server machine, as described in Installing the Siebel Database Server and Configuring the Siebel Database you may modify the database table and index creation scripts to specify the table space names you created for Siebel tables and indexes. For more information, see Guidelines for Overriding DB2 UDB Default Table Spaces for Database Objects.

These settings should be used only as guidelines for your initial configuration. Your final settings will vary based on the server hardware configuration, the number of users, and the type of workload.

Additional information on IBM DB2 UDB configuration is available from IBM, the hardware vendor, and other sources of documentation. Also refer to IBM documentation for additional information concerning tuning options for DB2 UDB.