IBM DB2 UDB zOS and OS/390 and z/OS-Specific Database Guidelines for Oracle Business Analytics Warehouse
Preinstallation and Deployment Requirements for Oracle BI Applications
3-5
3.3 IBM DB2 UDB zOS and OS/390 and z/OS-Specific Database
Guidelines for Oracle Business Analytics Warehouse
The following requirements apply to IBM DB2 RDBMS usage for zOS and OS/390:
The Oracle BI Applications communicate with IBM DB2 UDB for z/OS and
OS/390 (running on zSeries servers) through IBM DB2 Connect middleware.
The following editions of DB2 Connect are supported:
DB2 Connect Enterprise Edition (EE).
This edition is installed on a mid-tier
server such as an Informatica Server/Client, DAC, and Oracle Business
Intelligence.
DB2 Connect Unlimited Edition (UE).
This edition provides the functionality
of DB2 Connect Enterprise Edition but is priced differently.
NUM_ESTORE_SEGS 16
NIL
Restore 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
Note:
To avoid fatal deadlocks during the ETL, make sure that you
select the 'Session Level Retry on Deadlock' option in Informatica.
Table 32
(Cont.) Recommended DB2 Parameter Settings
Parameter
DB2 UDB V7
DB2 UDB V8 and V9
Notes
Summary :
IBM DB2 UDB zOS and OS/390 and z/OS-Specific Database Guidelines for Oracle Business Analytics Warehouse Preinstallation and Deployment Requirements for Oracle BI Applications 3-5 3.3 IBM DB2 UDB zOS and OS/390 and z/OS-Specific Database Guidelines for Oracle Business Analytics Warehouse The following requirements apply to IBM DB2 RDBMS usage for zOS and OS/390: The Oracle BI Applications communicate with IBM DB2 UDB for z/OS and OS/390 (running on zSeries servers) through IBM DB2 Connect middleware.
Tags :
oracle,udb,ibm,edition,connect,os390,500,zos,2560,business,new,database,25000