VDB2 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
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 member 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
-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 |
|