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 |
Siebel Data Warehouse Installation and Administration Guide, Version 7.5, Rev. C Published: 18 April 2003 |