IBM DB2

This topic is part of Requirements for Installing and Configuring the Siebel Database.

For IBM DB2, make sure that the following elements are defined for your Siebel database:

• Database alias. The DB2 database alias that you created when you installed the DB2 software.

• Table owner or database owner account user name and password. DB2 requires that you assign a user name and password to each database that you create.

  Before you install the tablespaces and indexes, you are prompted to edit the grantusr.sql script, enter this and related information, and execute the script. See Creating Table Owner and Administrator Accounts.

• Siebel index tablespace. The name of the tablespace on the DB2 server where the Siebel indexes are stored.

• Siebel 4-KB tablespace. The name of the tablespace on the DB2 server where the 4 KB Siebel data tables are stored.

• Siebel 16-KB tablespace. The name of the tablespace on the DB2 server where tables reside whose row length is equal to or greater than 4005 bytes, but less than 16384 bytes.

• Siebel 32-KB tablespace. The name of the tablespace on the DB2 server where tables reside whose row length is 32768 bytes.

• Statistics are generated automatically during table, index, and seed data installation, and during the Siebel Repository import process. However, it is recommended that statistics be kept up to date through standard database administration procedures.

• Make sure that you have installed the required IBM fix pack on your database server computer. For more information, see the Certifications tab on My Oracle Support.

• Make sure that IBM DB2 is properly configured and you have allocated disk space appropriate to your installation requirements.