Guidelines for Creating IBM DB2 Database Objects

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

Siebel CRM provides 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 the requirements for your deployment.

Use the settings in the script as guidelines for your initial configuration. Your final settings will vary depending 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 computer, as described in Installing Siebel CRM, you can modify the database table and index creation scripts to specify the tablespace names that you created for Siebel tables and indexes. For more information, see Guidelines for Overriding IBM DB2 Default Tablespaces for Database Objects.

Additional information about IBM DB2 configuration and tuning options is available from IBM, your hardware vendor, and other sources.