IBM DB2 V8 Fan User Manual


 
- recommended production initial definitions for DSNDB07 for an initial installation
(each should be on a separate volume):
(4) 4K TableSpaces @ 200 cylinders each
(2) 32K TableSpaces @ 200 cylinders each , Total = 1200 cylinders
5. Define archive log environment. If archiving to DASD, create a SMS storage group
and configure enough DASD to maintain enough archives between HSM migrations.
Develop and implement a HSM migration strategy. If archiving to tape then set
ARCWTOR=NO and ensure that tapes are available via a loader. The installation will
require at least 30 GB of archive space. There will be approximately 40 log archives
during the load phase of the installation. Another option is to use a hidden DB2
ZPARM. Setting OFFLOAD=NO will disable DB2 archive processing for the installation.
This should be removed after the installation.
6. Set DSNZPARMS , DSNTIPD installation panel values, and Buffer Pool
Parameters as per the SAP Database Administration Guide for SAP NetWeaver on
IBM DB2 UDB for z/OS. OSS Note 1032273 addresses the ZPARM recommendations
for DB2 9.
7. Install and Enable WLM Stored Procedures support as described in Chapter 3 of the
SAP Database Administration Guide for SAP NetWeaver on IBM DB2 UDB for z/OS.
SAP uses WLM established address spaces for DB2 Stored Procedures. WLM
dynamically creates and deletes address spaces and manages the work and the
number of address spaces according to a defined goal.
8. Set IRLM Parameters in the JCL: (use REGION=0M) (Watch for IEFUSI exit limit)
PC=YES (use IRLM Private Storage Area),
MLMT=4,
MAXCSA=0
DEADLOK=5,1
SCOPE=LOCAL (GLOBAL if DB2 Data Sharing is being used)
The PC and MAXCSA parameters are no longer used, but you must maintain them for
compatibility reasons. You must specify the parameters and values, but their values are
not used. DB2 V8 and DB2 9 require IRLM 2.2, which is delivered with DB2 V8 and
DB2 9. You must use the DB2–supplied IRLM procedure. To modify an existing IRLM
procedure for use with IRLM, you must do the following:
Add the MLMT (MEMLIMIT) parameter with the appropriate setting.
Specify YES for the PC parameter.
Specify 0 for the MAXCSA parameter.
9. Install Real Time Statistics and Stored Procedure DSNACCOR as described in
Chapter 3 of the SAP Database Administration Guide for SAP NetWeaver on IBM DB2
UDB for z/OS.
Copyright 2006
IBM Solutions Technical Sales (STS) 12/18/2007Page 19 of 51
12/18/2007
Planning and Preparation Guide for SAP NetWeaver Version 6.40: z/OS Implementation