Oracle Business Intelligence Applications Installation Guide ...
Document source : download.oracle.com
IBM DB2 UDB-Specific Database Guidelines for Oracle Business Analytics Warehouse
3-4
Oracle Business Intelligence Applications Installation Guide for Informatica PowerCenter Users
3.2 IBM DB2 UDB-Specific Database Guidelines for Oracle Business
Analytics Warehouse
Table 32
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.
AGG
W_*A
OTHER
Remaining W* tables
DIM_INDX
Indexes of W_*D tables
(for example, other tables would include W*G and W*GS tables)
FACT_INDX
Indexes of W_*F tables
OTHER_INDX
Remaining indexes of W* tables
Note:
To avoid fatal deadlocks during the ETL, make sure that you
select the 'Session Level Retry on Deadlock' option in Informatica.
Table 32
Recommended DB2 Parameter Settings
Parameter
DB2 UDB V7
DB2 UDB V8 and V9
Notes
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
Table 31
(Cont.) Recommended Tablespace Configuration
Tablespace Name
List of Tables
Summary :
IBM DB2 UDB-Specific Database Guidelines for Oracle Business Analytics Warehouse 3-4 Oracle Business Intelligence Applications Installation Guide for Informatica PowerCenter Users 3.2 IBM DB2 UDB-Specific Database Guidelines for Oracle Business Analytics Warehouse Table 32 provides guidelines for parameter settings for DB2 relational database management system (RDBMS) usage.
Tags :
tables,db2,database,2048,guidelines,16384,table,oracle,parameter,business,indexes,make,settings