Siebel Business Analytics Applications Installation and Administration Guide > Preinstallation Considerations for Analytics Applications >
IBM DB2 UDB-Specific Database Guidelines for Siebel Data Warehouse
Table 10 provides guidelines for parameter settings for DB2 relational database management system (RDBMS) usage. Use these guidelines as a starting point. You will need to make changes based on your specific database sizes, data shape, server size (CPU and memory), and type of storage. The database administrator should make changes to the settings based on performance monitoring and tuning considerations.
Table 10. Recommended DB2 Parameter Settings
|
|
|
|
SHEAPTHRES |
400000 |
400000 |
|
ASLHEAPSZ |
15 |
15 |
|
RQRIOBLK |
65535 |
65535 |
|
QUERY_HEAP_SZ |
16384 |
16384 |
|
JAVA_HEAP_SZ |
2048 |
2048 |
|
MAXAGENTS |
400 |
400 |
|
NUM_INITAGENTS |
10 |
10 |
|
NUM_POOLAGENTS |
200 |
200 |
|
INTRA_PARALLEL |
YES |
YES |
|
FCM_NUM_BUFFERS |
12288 |
12288 |
|
SHEAPTHRES_SHR |
N/A |
=SHEAPTHRES |
|
DBHEAP |
16384 |
16384 |
|
CATALOGCACHE_SZ |
5558 |
5558 |
|
LOGBUFSZ |
2048 |
2048 |
|
UTIL_HEAP_SZ |
10000 |
10000 |
|
NUM_ESTORE_SEGS |
16 |
NIL |
Estore is not needed in DB2 V8 64-bit because the V7 limit of 1.75 GB addressable memory has been lifted. |
ESTORE_SEG_SZ |
65536 |
NIL |
|
LOCKLIST |
25000 |
25000 |
|
APP_CTL_HEAP_SZ |
5000 |
5000 |
|
SORTHEAP |
4000 |
4000 |
|
STMTHEAP |
40960 |
40960 |
|
APPLHEAPSZ |
2560 |
2560 |
|
PCKCACHESZ |
2560 |
2560 |
|
STAT_HEAP_SZ |
20000 |
20000 |
|
DLCHKTIME |
10000 |
10000 |
|
MAXLOCKS |
50 |
50 |
|
LOCKTIMEOUT |
1200 |
1200 |
|
MAXAPPLS |
500 |
500 |
|
AVG_APPLS |
10 |
10 |
|
MAXFILOP |
500 |
500 |
|
GROUPHEAP_RATIO |
N/A |
70 |
New in V8 |
APPGROUP_MEM_SZ |
N/A |
30000 |
New in V8 |
DATABASE_MEMORY |
N/A |
AUTOMATIC |
New in V8 |
|