Bookshelf Home | Contents | Index | Search | PDF

Siebel Data Warehouse Installation and Administration Guide > Overview of Siebel Data Warehouse > Siebel Data Warehouse Database Requirements >

IBM DB2 UDB-Specific Database Requirements

---

The following requirements apply to DB2 RDBMS usage:

• IBM DB2 UDB for Windows 2000.
• ODBC driver for all connections must use the IBM DB2 ODBC Driver.
• Make the appropriate connections using DB2 Client Configuration Assistant.
• Create the user accounts that access the database. They must have SSE_ROLE and be set so that the .dll commands can be run (permissions to create tables).
• One login user needs to be created in an empty database. The database objects will be created using this user login.
• Recommended baseline parameters. Table 11 contains the recommended settings for these variables.

Table 11.  Recommended Variable Settings for IBM DB2 UDB Databases

Parameter	Recommended Setting	Notes
Datafile Size (including System)	At least 50% of Siebel transactional database size	Database managed
Isolation Level	cursor stability
Locklist	5000
Maxlock	50
Applheapsz	2560
Logfilsiz	8000
Logprimary	120
Logsecond	2
Tablespaces	16K or 32K page size	Database managed
Sortheap	4000	Sort list heap
Sheapthres	400000	Sort heap threshold

• In your Siebel transactional database, move the following tables to a tablespace separate from all other tables in the database:
  • S_ETL_COSTLST
  • S_ETL_CURR_RUN
  • S_ETL_ERRHLP
  • S_ETL_ERRLOG
  • S_ETL_EXCH_RATE
  • S_ETL_INC_STAT
  • S_ETL_I_IMAGE
  • S_ETL_LOV
  • S_ETL_PARAM
  • S_ETL_RUN
  • S_ETL_VI_IMAGE

    These tables are used by the Siebel Data Warehouse and should not be part of the routine backup processes.

For more information, see IBM's DB2 database configuration guide.

Bookshelf Home | Contents | Index | Search | PDF