Bookshelf Home | Contents | Index | Search | PDF

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

DB2-Specific Database Requirements

---

The following requirements apply to DB2 RDBMS usage:

IBM DB2 UDB for Windows NT.
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 ddl commands can be run (permissions to create tables).
All tablespaces (including System) should be of 16K or 32K page size and they should be database-managed.
In your Siebel Transaction Database (OLTP database), move the following tables to a tablespace separate from all other tables in the OLTP 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.

Datafile size must be at least fifty percent of Siebel Transaction Database size.
One login user needs to be created in an empty database. The database objects will be created using this user login.
Make sure that isolation level is cursor stability.
Use these baseline parameters:
locklist - 5,000
maxlock - 50
applheapsz - 2,560
logfilsiz - 2,500
logprimary - 5
logsecond - 20

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

Bookshelf Home | Contents | Index | Search | PDF