Siebel Installation Guide for Microsoft Windows > Configuring the RDBMS > Configuring an IBM DB2 UDB Database for Siebel Applications >

Guidelines for Creating DB2 UDB Database Objects


This topic is part of Configuring an IBM DB2 UDB Database for Siebel Applications.

Siebel Business Applications provide a sample script (CrBlankDB2UDBSiebelDEMO.sql), located in the DBSRVR_ROOT\DB2UDB directory. Use this script as a reference to help you create your own scripts for creating a blank Siebel Database based on your deployment's requirements.

Use the settings 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. Use a small, nonproduction environment for testing purposes.

Before using this script, read the file CrBlankDB2UDBSiebelDEMOReadMe.txt. See also Overview of Database Configuration.

After you install the Database Configuration Utilities on the Siebel Server machine, as described in Installing Siebel Enterprise Server and Related Components you can 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.

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

Siebel Installation Guide for Microsoft Windows Copyright © 2011, Oracle and/or its affiliates. All rights reserved. Legal Notices.