IBM DB2 9 Technical manual

Planning And Preparation Guide For SAP NetWeaver
7.0: z/OS Implementation:
D 2 V8
D 2 9
Albert D. Rodi
Consulting IT Specialist
I M Solution Technical Sales
International usiness Machines Corporation
1503 L J Freeway
Dallas, TX 75234
[phone] or TieLine 8-542-4791
E-mail: [email protected]
Copyright 2006 IBM Solutions Technical Sales (STS) 12/18/2007Page 1 of 51
12/18/2007
Planning and Preparation Guide for SAP NetWeaver Version 6 40: z/OS Implementation

Trademarks
The following are trademarks of the International usiness Machines Corporation in the United States and/or
other countries
AIX* On emand Business Logo
CICS* PR/SM
B2* Parallel Sysplex*
B2 Universal atabase pSeries*
e-business logo System z9
Enterprise Storage Server* System z
G PS* Tivoli*
Geographically ispersed Parallel Sysplex xSeries*
HiperSockets z/Architecture
IBM* z/OS*
IBM eServer z/VM*
IBM logo* zSeries*
IMS
* Registered trademarks of IBM Corporation
Intel is a registered trademark of the Intel Corporation in the United States, other countries or both.
Linux is a registered trademark of Linus Torvalds in the United States, other countries, or both.
Java and all Java-related trademarks and logos are trademarks of Sun Microsystems, Inc., in the United States and
other countries.
UNIX is a registered trademark of The Open Group in the United States and other countries.
Microsoft, Windows and Windows NT are registered trademarks of Microsoft Corporation.
SET and Secure Electronic Transaction are trademarks owned by SET Secure Electronic Transaction LLC.
SAP is a registered trademark of SAP AG, Walldorf , Germany
* All other products may be trademarks or registered trademarks of their respective companies.
Notes:
Performance is in Internal Throughput Rate (ITR) ratio based on measurements and projections using standard IBM benchmarks in a controlled
environment. The actual throughput that any user will experience will vary depending upon considerations such as the amount of multiprogramming in
the user's job stream, the I/O configuration, the storage configuration, and the workload processed. Therefore, no assurance can be given that an
individual user will achieve throughput improvements equivalent to the performance ratios stated here.
IBM hardware products are manufactured from new parts, or new and serviceable used parts. Regardless, our warranty terms apply.
All customer examples cited or described in this presentation are presented as illustrations of the manner in which some customers have used IBM
products and the results they may have achieved. Actual environmental costs and performance characteristics will vary depending on individual
customer configurations and conditions.
This publication was produced in the United States. IBM may not offer the products, services or features discussed in this document in other countries,
and the information may be subject to change without notice. Consult your local IBM business contact for information on the product or services
available in your area.
All statements regarding IBM's future direction and intent are subject to change or withdrawal without notice, and represent goals and objectives only.
Information about non-IBM products is obtained from the manufacturers of those products or their published announcements. IBM has not tested those
products and cannot confirm the performance, compatibility, or any other claims related to non-IBM products. Questions on the capabilities of non-IBM
products should be addressed to the suppliers of those products.
Prices subject to change without notice. Contact your IBM representative or Business Partner for the most current pricing in your geography.
Copyright 2006 IBM Solutions Technical Sales (STS) 12/18/2007Page 2 of 51
12/18/2007
Planning and Preparation Guide for SAP NetWeaver Version 6 40: z/OS Implementation

Contents
I General Preparation Steps
II z/OS Hardware Preparation
III AIX Hardware Preparation
IV z/OS Software Preparation
V B2 and B2 Connect Preparation
VI B2 Related OSS Notes
VII AIX Software Preparation
VIII Windows NT Hardware/Software Preparation
IX SAP Installation Preparation
X Sample BPXPARMxx Member
XI Sample B2 SNZPARMS
XII TCP/IP Connectivity
XIII Naming Conventions
XIV Application Server On z/OS Considerations
XV Sample OSA-Express GB Configuration
XVI B2 Backup/Recovery Notes
XVII SAP Automation And High Availability Solution
XVIII SAP Application Server On zLinux Considerations
XIX Sample SMS Storage Group Assignments
Copyright 2006 IBM Solutions Technical Sales (STS) 12/18/2007Page 3 of 51
12/18/2007
Planning and Preparation Guide for SAP NetWeaver Version 6 40: z/OS Implementation

What is new with SAP Web Application Server 7.0 ?
• The z/OS USS Application Server is no longer supported. However you can install the
Central Services on USS as part of a High Availability solution.
• rfcoscol is replaced by sapccmsr and SAPCL
 Transaction ST04 allows monitoring of remote B2 subsystems
 The mass processing tool to convert indexes to NOT PA E is available
(Transaction B2_IXFIX)
 Modifications have been made to the PTF Checker Tool
 New BA Cockpit Monitoring Tool in Basis Support Package 12
 B2 9 certified July 2007
What is new with SAP Web Application Server 6.40 ?
• B2 Version 8 is required for the SAP Web AS Release 6.40. Many new features of
B2 V8 are exploited:
- Table controlled partitioning
- System level backup and recovery
- Automatic extent management
- Accounting and WLM exploitation
- Transaction level accounting and workload management
- IFI enhancements
- Index only access for VARCHAR
• Unicode is now supported.
• B2 Connect is used to connect non-z/OS application servers to B2 (enhancements
in the tool db2radm to setup B2 Connect). ICLI is no longer used. For the Java stack,
the B2 J BC Universal river is delivered with B2 Connect and is used for
connectivity.
• Stored procedures have replaced the usage of FTP for JCL job submission.
• New features in the planning calendar (transaction B13)
- Exploitation of inline statistics and utilities TEMPLATE, MO IFY RECOVERY
and MO IFY STATISTICS
- Protection of changed utility skeletons possible
- New design
• Recommendations for B2 V8 system parameters (ZPARMs).
The SAP Solution Manager must be installed prior to any component installation.
This is used to generate a key used during the input phase of the installation.
General Preparation Steps
Copyright 2006 IBM Solutions Technical Sales (STS) 12/18/2007Page 4 of 51
12/18/2007
Planning and Preparation Guide for SAP NetWeaver Version 6 40: z/OS Implementation

1. Identify the technical implementation team members:
z/OS System Programmer
zLinux Administrator
Security Administrator
Unix System Services Administrator
Storage Administrator
Network Administrator
AIX/Windows Administrator
B2 BA
B2 Systems Programmer
R/3 Administrator
z/OS Capacity Planning & Performance Administrator
2. Available ocumentation (SAP):
- SAP Planning Guide for SAP NetWeaver for IBM DB2 UDB for z/OS
- Co ponent Installation Guide: SAP ERP 2005 ABAP+Java on AIX: IBM
DB2 UDB for z/OS
- Co ponent Installation Guide: SAP ERP 2005 ABAP+Java on Windows:
IBM DB2 UDB for z/OS
- Co ponent Installation Guide: SAP ERP 2005 ABAP+Java on Linux: IBM
DB2 UDB for z/OS
- SAP ERP 2005 SR1 ASCS+SCS on z/OS: IBM DB2 UDB For z/OS:
Installation Guide
- SAP Security Guide for IBM DB2 UDB for z/OS
- SAP Database Ad inistration Guide for SAP NetWeaver on IBM DB2
UDB for z/OS
- Master Guide: SAP NetWeaver 2004s
- Technical Infrastructure Guide: SAP NetWeaver 2004s
- SAPinst Trouble Shooting Guide for SAP Web AS Java Installation
- SAP Enterpise Services Architecture and SAP NetWeaver on IBM zSeries :
Technology Preview
Copyright 2006 IBM Solutions Technical Sales (STS) 12/18/2007Page 5 of 51
12/18/2007
Planning and Preparation Guide for SAP NetWeaver Version 6 40: z/OS Implementation

- Installation of SAP Solution Manager
- Configuration of SAP Solution Manager
- Front End Installation
- Homogeneous and Heterogeneous System Copy for SAP Systems based
on NetWeaver 2004s
3. Available ocumentation (IBM):
- High Availability for SAP on zSeries Using Autonomic Computing
Technologies (SC33- 8206)
- SAP on B2 U B for OS/390 and z/OS: Implementing Application
Servers On Linux for zSeries (SG24- 6847)
- SAP on IBM B2 U B for OS/390 and z/OS: Best Practices for
Installing or Migrating to B2 V8
(websmp202 sap-ag de/~form/sapnet?_SHORTKEY=01100035870000274486&)
- Tips for Installing B2 Connect V8 on SAP with B2 U B for z/OS V8
(www ibm com/support/docview wss?rs=64&uid=swg27005934)
- SAP on IBM B2 U B for z/OS: Best Practices for Installing or Migrating
to B2 9
(service.sap.com/SolutionManagerBP)
- Point-in-time recovery using B2 V8 for z/OS RESTORE SYSTEM utility
and SET LOG SUSPEN
- SAP on B2 for z/OS and OS/390: High Availability and Performance
Monitoring with ata Sharing (SG24-6950)
- SAP on B2 U B for OS/390 and z/OS: High Availability Solution
Using System Automation (SG24- 6836)
- SAP R/3 on DB2 UDB for OS/390 and z/OS: Connectivity Guide
5th Edition (IBM SC33-7965-04)
- B2 for z/OS and OS/390: Tools For Performance Management
(IBM SG24-6508)
- B2 for z/OS and OS/390 : ata Management Tools Update
(IBM SG24- 6406)
- SAP on B2 for z/OS and OS/390: B2 System Cloning
Copyright 2006 IBM Solutions Technical Sales (STS) 12/18/2007Page 6 of 51
12/18/2007
Planning and Preparation Guide for SAP NetWeaver Version 6 40: z/OS Implementation

(IBM SG24- 6287)
- B2 U B for z/OS V8: Through the Looking Glass and What SAP
Found There (IBM SG24- 7088)
- isaster Recovery with B2 U B for z/OS (SG24-6370)
- B2 Performance Expert for z/OS (SG24- 6867)
- B2 U B for z/OS Version 8 Technical Preview (SG24- 6871)
- istributed Functions of B2 for z/OS and OS/390 (SG24- 6952)
- SAP on B2 for z/OS: Multiple Components In One atabase(MCO )
(SG24- 6914)
- B2 for z/OS Version 8 : Everything You Ever Wanted to Know...and
More (SG24-6079)
- B2 9 for z/OS: Performance Topics (SG24-7473)
- Enhancing SAP by Using B2 9 for z/OS (SG24-7239)
Note: SAP Manuals are available at:
service.sap.com/instguides
service.sap.com/erp-inst
service.sap.com/installNW2004s
IBM Manuals are available at:
www.s390.ibm.com/zos/bkserv
IBM Redbooks are available at:
www.redbooks.ibm.com
3. Plan and conduct a planning session/readiness review for the
installation and migration (if migrating an existing SAP database).
4. Obtain the required hardware/software plus all necessary PTFs (OSS Note 81737).
Copyright 2006 IBM Solutions Technical Sales (STS) 12/18/2007Page 7 of 51
12/18/2007
Planning and Preparation Guide for SAP NetWeaver Version 6 40: z/OS Implementation

5. Important OSS Notes: (service.sap.com/notes)
660528: Requirements to run SAP NetWeaver on zSeries
661260: Transports and Support Pac kages for 6.40
728743: zSeries: Release of B2 V8 for SAP Components
746924: Planning information for customers with SAP on zSeries
606682: High availability and automation solution for Linux zSeries
563060: B2/390: Configuring the AppServer on Linux for zSeries
731937: B2-z/OS: Customizing B2 Connect for WebAS 6.20 and B2 V8
710466: Upgrade to 6.40 - OS Platforms not supported
183311: B2/390: Automated PTF Check
427748: B2-z/OS: CCMS corrections (6.10, 6.20, 6.40,7.00)
943145: B2-z/OS: Transports and Support Packages for 7.0
943144: B2-z/OS: Transports and Support Packages for 7.0
823245: B2-z/OS: Transports and Support Packages for 7.0
858969: SAP NetWeaver 2004s Installation:IBM B2 U B for z/OS
81737: B2/390: APAR List
146289: Parameter Recommendations for 64-Bit SAP Kernel
138906: B2/390: Planning Info (release,connectivity matrix)
103135: B2/390: Installing saposcol manually
682077: B2-z/OS: Premigration checks for B
35010: Service connections: Composite note (overview)
46902: Security aspects in remote access
44864: SAP Remote Services: Technical preparation
171356: SAP Software on Linux: Essential Comments
209384: CCMS Agent Technology
978817: B2 for z/OS OEM Package
805390: SAP Solution Manager is required for SAP Software
407325: Released Operating Systems SAP Kernel 6.x/7.x
852008: Release restrictions for SAP NetWeaver 2004s
855498: Installation Prerequisite Checker
856272: SAP Software on UNIX - OS ependencies NetWeaver 2004s
855297: SAP ERP 2005 Installation on UNIX
852235: Release restrictions for SAP ERP 2005
851251: SAP NetWeaver 2004s Installation on UNIX
811923: Generating the SAP Solution Manager Key
848950: SAP NetWeaver 2004s Installation on Windows
815202: B2 for z/OS: Upgrade to SAP NW AS 7.0
611361: Configuring the App Server on Linux for zSeries
563060: SAP ERP Central Component 5.0 on UNIX
544623: New Installation of Unicode SAP Systems
73606: R/3 Language Combinations (non-Unicode)
35010: Service Connections:Composite Note
46902: Security aspects in remote access
33135: Guidelines for OSS1
31515: Service Connections
Copyright 2006 IBM Solutions Technical Sales (STS) 12/18/2007Page 8 of 51
12/18/2007
Planning and Preparation Guide for SAP NetWeaver Version 6 40: z/OS Implementation

797084: SUSE Linux Enterprise Server 9: Installation Note
892818: Application servers on Linux for zSeries: Settings
821904: Separating SCS instances for ABAP and J2EE
686905: B2 for z/OS: IC Corrections (6.40, 7.0)
818291: zSeries: Windows 64 bit app server
144864: SAP Remote Services: Technical preparation
6. Prepare a project plan for the implementation. The following architecture highlights
should be addressed:
Parallel Sysplex with B2 ata Sharing Configuration
SAP Sysplex Failover Scenarios for High Availability
SAP High Availability Enqueue Instance (Central Services Instance)
SAP Application Server on zLinux
Network Connectivity
atabase Backup/Recovery
isaster Recovery
7. Prepare a migration plan for submission to SAP if necessary.
8. Setup OSS connection, FTP capability to SAP.
9. Order R/3 eveloper Keys if necessary.
10. Generate Backup/Recovery Plan for z/OS, zLinux, AIX, Windows, and the SAP
atabase.
Copyright 2006 IBM Solutions Technical Sales (STS) 12/18/2007Page 9 of 51
12/18/2007
Planning and Preparation Guide for SAP NetWeaver Version 6 40: z/OS Implementation

II z/OS Hardware Preparation
1. Review Checklist in Installation Manual and at service.sap.co /platfor s for
supported z/OS server models.
2. etermine Hardware Configuration by completing the SAP sizing
questionnaire for R/3. Review the sizing deliverable document prepared by the
IBM ISV TechLine Sizing epartment in conjunction with your IBM Sales Team or
implementation partner. Memory estimates will be provided as well. The questionnaire
is available online at:
http://www.ibm.com/erp/sizing or by request from [email protected].
3. Minimum AS requirements for new installation are:
A. Non-Production (65) + (n) 3390-3 volumes
(60) 3390-3 volumes for SAP data
(2) 3390-3 volumes for B2 active logs
(1) 3390-3 volume for B2 catalog, directory, BS S
(2) 3390-3 volumes for B2 SN B07
(n) 3390-3 volumes for z/OS datasets(LINKLIB, PROCLIB, etc.)
(5) 3390-3 volumes for each z/VM LPAR (RES, Spool, Paging)
B. Each additional Non-Production system (65) 3390-3 volumes
C. Production (13) + (n) 3390-3 volumes plus (x) volumes for SAP data
(6) 3390-3 volumes for B2 active logs
(3) 3390-3 volumes for B2 catalog, directory, BS S
(4) - (15) 3390-3 volumes for B2 SN B07
(x) 3390-3 volumes for SAP data (minimum 60 for installation)
(n) 3390-3 volumes for z/OS datasets
(5) 3390-3 volumes for each z/VM LPAR (RES, Spool, Paging)
(plus additional volumes if B2 logs are archived to AS )
(PAV implementation is highly recommended)
z/Linux Application Server for ECC 6.0 (NetWeaver 7.0):
Copyright 2006 IBM Solutions Technical Sales (STS) 12/18/2007Page 10 of 51
12/18/2007
Planning and Preparation Guide for SAP NetWeaver Version 6 40: z/OS Implementation