Bookshelf Home | Contents | Index | Search | PDF |
Siebel Data Warehouse Installation and Administration Guide > Installing and Configuring Siebel Data Warehouse > Database Parameters and Requirements for Siebel Data Warehouse >
IBM DB2 UDB Windows 2000-Specific Database Requirements for Siebel Data Warehouse
The following requirements apply to DB2 relational database management system (RDBMS) usage:
- 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.
- The recommended baseline parameters are as follows:
MON_HEAP_SZ = 90
JAVA_HEAP_SZ = 2048
SHEAPTHRES = 400000
ASLHEAPSZ = 15
RQRIOBLK = 32767
QUERY_HEAP_SZ = 1000
MAXAGENTS = 400
NUM_POOLAGENTS = 200
FCM_NUM_BUFFERS = 12288
INTRA_PARALLEL = YES
DBHEAP = 16384
DBHEAP = 16384
DATABASE_MEMORY = AUTOMATIC
CATALOGCACHE_SZ = 5558
LOGBUFSZ = 256
UTIL_HEAP_SZ = 10000
BUFFPAGE = 30000
ESTORE_SEG_SZ = 65536
NUM_ESTORE_SEGS = 16
LOCKLIST = 50000
APPGROUP_MEM_SZ = 30000
GROUPHEAP_RATIO = 70
APP_CTL_HEAP_SZ = 5000
SHEAPTHRES_SHR = SHEAPTHRES)
SORTHEAP = 40000
STMTHEAP = 40960
APPLHEAPSZ = 2560
PCKCACHESZ = 800
STAT_HEAP_SZ = 9000
DLCHKTIME = 10000
MAXLOCKS = 50
LOCKTIMEOUT = 1200
MAXAPPLS = 500
AVG_APPLS = 10
MAXFILOP = 500
LOGFILSIZ = 63753
LOGPRIMARY = 200
LOGSECOND = 2
SOFTMAX = 100
LOGRETAIN = OFF- All tables with a prefix of S_ETL need to be in a tablespace separate from the other OLTP tables. These ETL tables are used by the Siebel Data Warehouse and should not be part of the routine backup processes.
A complete listing of these tables can be found in Siebel Data Warehouse Data Model Reference.
Bookshelf Home | Contents | Index | Search | PDF |
Siebel Data Warehouse Installation and Administration Guide Published: 11 March 2004 |