Filter
Top Products
V DB2 Preparation
1. Install DB2 subsystem. A separate ICF catalog is recommended for each DB2
subsystem based on the High Level Qualifier for DB2 datasets. the ICF Catalog should
contain only the catalogued objects for a single DB2 subsystem. However, with DB2 V8
and DB2 9 the recommendation is to have two ICF Catalogs, one for each Copy Pool.
There is a DataBase Copy Pool, that will contain the SAP tablespaces, SAP
indexspaces, DB2 Catalog, and DB2 Directory. There is also a Log Copy Pool that will
contain the Active Log Datasets and the BSDS Datasets. The reason for this separation
is that during a RESTORE SYSTEM only the DataBase Copy Pool will be restored to
DASD, not the Log Copy Pool, and we do not want the ICF Catalog containing the Logs
and BSDS restored. This is explained in Chapter 7 of the redbook SG24-7088.
Review all of the setup information in Chapter 3 of the SAP Database Administration
Guide for SAP NetWeaver on IBM DB2 UDB for z/OS.
This chapter describes in detail the setup activities such as RRS, Stored Procedure
Setup, and z/OS Unicode Conversion Services.
2. Apply all recommended PTFs from OSS Note 81737.
3. Modify group attach name in SYS1.PARMLIB(IEFSSNxx) if using data sharing. The
recommendation is to use the SAP SID for the group attach name, and the SAP SID
followed by a member number for each DB2 memb er within the group. See the
recommended naming conventions in Section XIV.
4. Configure DB2 active log datasets and DSNDB07:
- for a nonproduction system (3) log datasets @ 1000 3390-3 cylinders each for
LOGCOPY1 and LOGCOPY2 minimum on separate volumes
- for a production system (6) volumes are recommended for active log datasets
(one dataset per volume)
- for installation disable archiving with the hidden zparm OFFLOAD=NO and use
(6) volumes for active log datasets (one dataset per volume)
- place active log datasets and BSDS datasets on separate controllers
for maximum availability
- recommended production initial definitions for DSNDB07 for a large installation
(each should be on a separate volume, ~1300 logged in users) :
(7) 4K TableSpaces @ 660 cylinders each
(5) 4K TableSpaces @ 500 cylinders each
(3) 32K TableSpaces @ 185 cylinders each , Total = 7675 cylinders
Copyright 2006
IBM Solutions Technical Sales (STS) 12/18/2007Page 18 of 51
12/18/2007
Planning and Preparation Guide for SAP NetWeaver Version 6.40: z/OS Implementation