IBM DB2 V8 Manuel d'utilisateur

Planning And Preparation Guide For SAP NetWeaver 7.0: z/OS Implementation:

II z/OS Hardware Preparation1. Review Checklist in Installation Manual and at service.sap.com/platforms forsupported z/OS server models.2. Determ

1.2 GB (Temporary installation disk space)2 x zLinux Guest Memory (Swap Space) 4.3 GB (temporary disk space for every Installation DVD to be copied l

III AIX Hardware Preparation1. Review Checklist in theComponent Installation Guide : SAP ERP 2005 ABAP+Javaon AIX: IBM DB2 UDB for z/OS for b

IV z/OS Software Preparation1. Review Software Checklist in Installation Manual. REQUIRED•z/OS 1.6* or higher with the following components inst

**Documentation and sample scripts for TSA are available from IBM. If the customerchooses an equivalent product they take full responsibility for con

4. Define the necessary users via RACF definitions (review the SAP Security Guide forIBM DB2 UDB for z/OS): - define z/OS groupid <SCHEMA

9. Configure the TCP/IP protocol for GB Ethernet:A. Define the z/OS I/O configuration for the OSA-ExpressCard: - Define channel path ID for OSA-Expr

SAPCL as per Chapter 4 of the SAP Planning Guide for SAP NetWeaver for IBM DB2UDB for z/OS. These processes run under Unix System Services (USS). 1

V DB2 Preparation1. Install DB2 subsystem. A separate ICF catalog is recommended for each DB2subsystem based on the High Level Qualifier for DB2 da

- recommended production initial definitions for DSNDB07 for an initial installation (each should be on a separate volume):

TrademarksThe following are trademarks of the International Business Machines Corporation in the United States and/orother countriesAIX*

10. Install the Control Center Stored Procedures required by SAP as described indescribed in Chapter 3 of the SAP Database Administration Guide for S

15. Establish and test DB2 Backup/Recovery Procedures. These proceduresshould include a combination of DB2 and non-DB2 utilities in order to handle v

16. The recommendation is to develop a DB2 system libraries configuration that allowseach DB2 subsystem to be migrated to a new level of DB2, or DB2

VI DB2 Related OSS Notes 1043951: Release of DB2 9 for SAP components 1072066: DBA Cockpit: New functi

509529 DB2 Changing the DB Host 513750 DB2 Data Sharing Topology 390016 DB2/390 BW: DB Settin

VII AIX Software Preparation1. Review Checklist in the Installation Guide: SAP ERP 2005 ABAB+Java on AIX: IBMDB2 UDB for z/OS for base Software

VIII Windows Hardware/Software Preparation 1. Review Checklist in Component Installation Guide: SAP ERP 2005 SR1 ABAP+Javaon Windows:IBM DB2 UDB fo

IX SAP Installation Preparation1. Order SAP Installation Kit.2. Build project plan for installation.3. Setup OSS connection to SAP and test FTP

X Sample BPXPRMxx MemberMAXPROCSYS(4096)MAXPROCUSER(200)MAXTHREADTASKS(1000)MAXTHREADS(1000)MAXUIDS(200)MAXFILEPROC(2000) MAXFILESIZ

FILESYSTYPE TYPE(HFS) ENTRYPOINT(GFUAINIT) ROOT FILESYSTEM('OMVS.ROOT') TYPE(HFS) MODE(RDWR) PARM('')MOUNT FILESYSTEM('OMVS.S

ContentsI General Preparation StepsII z/OS Hardware PreparationIII AIX Hardware PreparationIV z/OS S

XI Sample DB2 DSNZPARMS DB2 V8 * = required/recommended value for SAPDSN6ENV MVS=XADSN6SPRM RESTART,ALL,ABEXP=YES,ABIND=Y

RECALL=YES,RECALLD=120, * RELCURHL=YES, * RETLWAIT=1, (Data Sharing only)RGFCOLID=DSNRGCOL,

DSN6LOGP DEALLCT=(1440),MAXARCH=500,MAXRTU=2, * OUTBUFF=4000, * TWOACTV=YES, * TWOARCH=YES DSN6SYSP AUDITST=NO,

* IDTHTOIN=0,RESYNC=2,RLFERRD=NOLIMIT,TCPALVER=YESDSN6GRP DSHARE=NO,GRPNAME=S4A,MEMBNAME=DNX1,COORDNTR=NO,ASSIST=NOENDDSNHDECM CHARSET=ALPHANUM

DB2 9 * = required/recommended value for SAPDSN6ENV MVS=XADSN6SPRM RESTART,ALL,ABEXP=YES,ABIND=YES,

* PARTKEYU=YES, RECALL=YES,RECALLD=120, * RETLWAIT=1, (Data Sharing only)RGFCOLID=DSNRG

TSTAMP=YES,UNIT=CART,UNIT2=CARTDSN6LOGP DEALLCT=(1440),MAXARCH=500,MAXRTU=2, * OUTBUFF=4000, * TWOACTV=YES, * TWOARCH=

STATIME=30,STORMXAB=5,STORTIME=180, * SYNCVAL=30,TRACSTR=NO,TRACTBL=16,

TIMELEN=0END Copyright 2006 IBM Solutions Technical Sales (STS) 12/18/2007Page 38 of 51 12/18/2007 Planning and Prep

XII TCP/IP Connectivity - required for SAP NetWeaver - strategic communications protocol - any HW supporting standard TCP/IP ca

What is new with SAP Web Application Server 7.0 ?• The z/OS USS Application Server is no longer supported. However you can install theCentral Servic

XIII Naming Conventions 1. The following elements should be part of an overall naming convention plan: SAP SID

XIV Application Server On z/OS Considerations* Note that only the SAP Central Services ASCS and SCSare now supported on Unix System Services unde

XV Sample OSA-Express GB Configuration SYS1.VTAMLST(XXTRL) XXTRL VBUILD TYPE=TRL * TRLEGBF8 TRLE LNCTL=MPC,

XVI DB2 Backup/Recovery Notes (OSS Note 83000)NOTE: The procedures described here are applicable to DB2 Version 8. Version 8provides two new uti

Recover to prior point in time - A recovery of all tablespaces, indexspaces, DB2 catalog, and DB2 Directory to aprevious log RBA (three ways to acom

- Recover to a prior point in time corresponding to the time of FlashCopy - Reset volumes using FlashCopy, including BSDS and logs - Restart

DB2 Version 8 EnhancementsDB2 Version 8 enhances the SAP backup and recovery process by providing two newsystem utilities for system level backup and

XVII SAP Automation And High Availability Solution 1. The following OSS Notes should be reviewed: 56999

XVIII SAP Application Server on zLinux Considerations1. Review the latest version of OSS Note 81737 for the supported Linux distribution.

7. Recommendations from the joint IBM/SAP Platform Team: Always use the latest z/VM release available , currently z/VM 5.3 Apply z/VM 5.1 APAR 636

1. Identify the technical implementation team members: z/OS System Programmer zLinux Administrator Secur

XIX Sample SMS Storage Group Assignments1. Here is a sample assignment methodology for setting up SMS Storage Groups. Onerecommendation is to name

ICF Catalog Names: CATALOG.SAPDB2.DR1LOG CATALOG.SAPDB2.DR1USR CATALOG.SAPDB2.DR1DB2

- Installation of SAP Solution Manager - Configuration of SAP Solution Manager - Front End Installation

(IBM SG24- 6287) - DB2 UDB for z/OS V8: Through the Looking

5. Important OSS Notes: (service.sap.com/notes) 660528: Requirements to run SAP NetWeaver on zSeries 661260: Trans

797084: SUSE Linux Enterprise Server 9: Installation Note 892818: Application servers on Linux for zSeries: Settin