IBM DB2 9 Planning Manual Download

Page: 1 / 51

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

DB2 V8
DB2 9

Albert D. Rodi

Consulting IT Specialist
IBM Solution Technical Sales
International Business Machines Corporation
1503 LBJ Freeway
Dallas, TX 75234
(972) 280-4791 or TieLine 8-542-4791
E-mail: [email protected]

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

Summary of Contents for DB2 9

Page 1: ...Solution Technical Sales International Business Machines Corporation 1503 LBJ Freeway Dallas TX 75234 972 280 4791 or TieLine 8 542 4791 E mail adrodi us ibm com Copyright 2006 IBM Solutions Technica...

Page 2: ...uration and the workload processed Therefore no assurance ca n be given that an individual user will achieve throughput improvements equivalent to the performance ratios stated here IBM hardware produ...

Page 3: ...x Member XI Sample DB2 DSNZPARMS XII TCP IP Connectivity XIII Naming Conventions XIV Application Server On z OS Considerations XV Sample OSA Express GB Configuration XVI DB2 Backup Recovery Notes XVII...

Page 4: ...and workload management IFI enhancements Index only access for VARCHAR Unicode is now supported DB2 Connect is used to connect non z OS application servers to DB2 enhancements in the tool db2radm to s...

Page 5: ...ERP 2005 ABAP Java on Windows IBM DB2 UDB for z OS Component 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...

Page 6: ...uid swg27005934 SAP on IBM DB2 UDB for z OS Best Practices for Installing or Migrating to DB2 9 service sap com SolutionManagerBP Point in time recovery using DB2 V8 for z OS RESTORE SYSTEM utility an...

Page 7: ...rformance Topics SG24 7473 Enhancing SAP by Using DB2 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 Manu...

Page 8: ...nnections 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 9...

Page 9: ...ta Sharing Configuration SAP Sysplex Failover Scenarios for High Availability SAP High Availability Enqueue Instance Central Services Instance SAP Application Server on zLinux Network Connectivity Dat...

Page 10: ...3390 3 volume for DB2 catalog directory BSDS 2 3390 3 volumes for DB2 DSNDB07 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 additio...

Page 11: ...through ICKDSF DASD initialization VVDS should be 180 tracks and the VTOC Index should be 50 tracks Triple these values if the DASD geometry is 3390 9 For 3390 54 geometry use 8 000 tracks for the VTO...

Page 12: ...be provided as well The questionnaire is available online at http www ibm com erp sizing or by request from eSizings us ibm com 3 Minimum required disk space for a standard installation is 20GB 4 3GB...

Page 13: ...Sdfp base element Provides storage data program and device management functions Related optional features are DFSMSdss optional zOS feature FlashCopy volume level dumps and restores DFSMShsm optional...

Page 14: ...s390x 2 6 5 7 244 HIGHLY RECOMMENDED FOR zLINUX APPLICATION SERVERS z VM 5 3 for running zLinux application servers as VM guests If using zLinux Application Servers under z VM CPINT is available for...

Page 15: ...ters by modifying SYS1 PARMLIB BPXPARMxx including the Physical File System definition for the TCP IP communication protocol stack Integrated INET is recommended over Common INET See Sample BPXPRMxx i...

Page 16: ...in the SAP Planning Guide for SAP NetWeaver for IBM DB2 UDB for z OS 13 Cache the DB2 User Catalog catalogs the SAP tablespaces and indexspaces in a Data Space accessed through VLF To do this add the...

Page 17: ...ns FMID JBB772S for z OS and z OS e V1 7 Http www 03 ibm com servers eserver zseries zos downloads Install the service identified in the program directory that comes with this Web deliverable and the...

Page 18: ...n 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...

Page 19: ...ter 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 s...

Page 20: ...EX SAPR3 is the default schema 12 Setup the DB2 DDF environment as described in Chapter 3 of the SAP Database Administration Guide for SAP NetWeaver on IBM DB2 UDB for z OS 13 Install DB2 Connect V8 1...

Page 21: ...educed providing a process that can be accomplished in a couple of hours Recommended initial backup procedure Weekly 1 Full DB2 Image Copy Of All R 3 Tablespaces SHRLEVEL CHANGE or REFERENCE 2 copies...

Page 22: ...ould be changed to point to the N 1 level of system libraries You would still maintain separate SDSNEXIT libraries for each subsystem or data sharing member 17 Review DB2 virtual storage consideration...

Page 23: ...ements to run SAP NetWeaver on zSeries 717935 FTP replacement by Stored Procedures 82953 Bufferpool Tuning 958252 SAPCL FAQ 26317 LOGON Group for Load Balancing 38119 SAPLOGON Administration 184399 Cr...

Page 24: ...OS Load of alert router fails 846145 DB2 for z OS saving space when you load using R3load 908770 DB2 for z OS SAP Java performance optimizer 958252 SAPCL FAQ 930025 Stored Procedure SAPCL configurati...

Page 25: ...rmance Toolbox and Performance AIDE for POWER Version 3 0 2 Apply all recommended PTFs as per OSS note 81737 3 Configure the GbE adapter for the GbE LAN 4 Reboot AIX and verify z OS TCP IP connections...

Page 26: ...English International Version of one of Windows Server 2003 Standard Edition Windows Server 2003 Enterprise Edition Windows Server 2003 Datacenter Edition 9 DB2 Connect 10 Windows Resource Kit is hig...

Page 27: ...ck 4 Obtain all necessary OSS notes 5 Gather the information necessary to respond to the SAPinst system parameters required for the installation These are documented in the Component Installation Guid...

Page 28: ...6432 IPCSHMMPAGES 524287 IPCSHMNSEGS 100 IPCSEMNIDS 4096 IPCSHMNIDS 4096 IPCSEMNSEMS 32767 IPCSEMNOPS 32767 MAXMMAPAREA 4096 MAXCORESIZE 2147483647 MAXASSIZE 2147483647 MAXCPUTIME 2147483647 MAXSHAREP...

Page 29: ...POINT EZBPFINI NETWORK DOMAINNAME AF_INET DOMAINNUMBER 2 MAXSOCKETS 25000 TYPE INET End of TCP IP OR Common INET Transport for TCP IP FILESYSTYPE TYPE CINET ENTRYPOINT BPXTCINT SUBFILESYSTYPE NAME TCP...

Page 30: ...IBMUSER DESCSTAT YES DLITOUT 0 DSMAX 6000 EDMSTMTC 300000 EDPROP NO EXTSEC NO EVALUNC YES HOPAUTH YES IRLMAUT YES IRLMPRC SID IRLM IRLMSID INX1 IRLMRWT 600 IRLMSWT 300 LRDRTHLD 10 MAXRBLK 100000 MAXKE...

Page 31: ...128 STATSINT 30 SYSADM SYSADM SYSADM2 P47208 SYSOPR1 SYSOPR SYSOPR2 P47208 UTIMOUT 3 XLKUPDLT TARGET DSN6ARVP ALCUNIT TRK CYL ARCWRTC 1 3 4 11 ARCWTOR NO ARCPFX1 DNX1SYS ARCHLOG1 ARCPFX2 DNX1SYS ARCHL...

Page 32: ...00000 LOBVALS 50000 MAXDBAT 64 1 3 number of all SAP work processes MGEXTSZ YES MON YES MONSIZE 500000 PCLOSET 25 PCLOSEN 15 RLF NO RLFTBL 01 RLFERR NOLIMIT RLFAUTH SYSIBM ROUTCDE 1 3 4 11 SMFACCT 1 2...

Page 33: ...DB2 supports translation between SCCSID and ASCCSID do not use 500 MCCSID 65534 GCCSID 65534 ENSCHEME ASCII DATE ISO DATELEN 0 DECARTH DEC15 DECIMAL PERIOD DEFLANG C DELIM DEFAULT MIXED NO SQLDELI DE...

Page 34: ...T min 150MB EDMSTMTC 300000 EDMPOOL value presented by DB2 install CLIST min 64MB EDPROP NO EXTSEC NO EVALUNC YES HOPAUTH YES IRLMAUT YES IRLMPRC SID IRLM IRLMSID INX1 IRLMRWT 600 IRLMSWT 300 LRDRTHLD...

Page 35: ...OLL YES STATSINT 30 SYSADM SYSADM SYSADM2 P47208 SYSOPR1 SYSOPR SYSOPR2 P47208 SYSTEM_LEVEL_BACKUPS YES TABLES_JOINED_THRESHOLD 10 UTIMOUT 3 XLKUPDLT TARGET DSN6ARVP ALCUNIT TRK CYL ARCWRTC 1 3 4 11 A...

Page 36: ...IDFORE 60 IDXBPOOL BP3 IMPDSDEF NO IMPTSCMP YES IXQTY 720 LBACKOUT NO LOGAPSTG 100 LOBVALA 1GB LOBVALS 50GB MAXDBAT 200 100 and at least 1 3 times the sum of SAP work processes that use DB2 Connect s...

Page 37: ...RDNTR NO ASSIST NO END DSNHDECM CHARSET ALPHANUM ASCCSID 819 AMCCSID 65534 AGCCSID 65534 APPENSCH EBCDIC SCCSID 37 or any value 640 and 700 MCCSID 65534 GCCSID 65534 ENSCHEME ASCII DATE ISO DATELEN 0...

Page 39: ...evice number DEVICE device_name LCS lcs_address Link associates the TCP IP link name with the network protocol attached to the port and the TCP IP device name LINK link_name network_protocol link_numb...

Page 40: ...G SGDR1ARC SGDR1SAP SGDR1IC DB2 Connect Instance Name DR1INST1 DB2 Connect Userid DR1DB2C DDF Location Name DR1DDF USS superuser to run saposcol sapccmsr DR1SUSER 2 For multiple mySAP com components c...

Page 41: ...OS since this will affect the processing and memory requirements 3 Review BPXPRMxx parameters TCP IP setup and filesystem setup as documented in the SAP Planning Guide for SAP NetWeaver for IBM DB2 U...

Page 42: ...LINK GIGAF8 IPAQGNET PORTGBF8 HOME 10 1 1 254 GIGAF8 GATEWAY Direct Routes Routes that are directly connected to my interface Network First Hop Link Name Packet Size Subnet Mask Subnet VA 10 0 0 0 GI...

Page 43: ...Online used by almost all customers used for recover to cu rrent Volume Level DB2 Suspend Log FlashCopy SnapShot EMC TimeFinder DB2 Resume Log used as a base for prior point in time recovery Need to p...

Page 44: ...need recovering is to analyze the archive logs that have been created between the two points in time The recommendation is to put an automated process in place to analyze the archive logs as they are...

Page 45: ...arge enough then archives won t be required Follow the same steps for Conditional Restart except specify the LOGONLY option on the RECOVERY commands If using volume level copies to re establish the da...

Page 46: ...e Groups for each Storage Group in a Copy Pool The high level steps for performing a backup recovery are Use the DFSMS ISPF Panels to define the Copy Pool Source Storage Group and Backup Storage Group...

Page 47: ...ting Technologies SC33 8206 4 The following software is required for the HA Solution on z OS z OS V1 6 or later DB2 UDB For z OS V8 1 Tivoli Netview for z OS 5697 ENV Tivoli Systems Automation for zSe...

Page 48: ...DB2 for OS 390 and z OS Connectivity Guide SC33 7965 03 5 OSS Notes 81737 DB2 390 APAR List 563060 DB2 390 Kernel Parameter for Linux on zSeries 386605 SAP Memory Management for zSeries 6 Documentatio...

Page 49: ...es and tuning hints please see http www 128 ibm com developerworks linux linux390 index html Use multiple swap volumes to avoid I O bottlenecks Always use the latest available Linux kernel currently S...

Page 50: ...CF Catalog for Active Logs BSDS Archive Logs ARCH DB2 Archive Log Datasets SGDR1ARC CAT DB2 Catalog Directory DSNDB07 SGDR1CAT DB2 System Libraries ICF Catalog for Catalog Directory System Libraries D...

Page 51: ...E Page Datasets SORT Sort Datasets SOFTW Software Library Datasets HFS USS HFS Datasets 2 For implementation of the new DB2 V8 and DB2 9 utilities BACKUP SYSTEM and RESTORE SYSTEM DB2 requires two SMS...

Search results

Summary of Contents for DB2 9

Reviews:

Related manuals for DB2 9

Brands by name

Popular brands

IBM DB2 9, Planning Manual

Search results

Summary of Contents for DB2 9

Reviews:

Related manuals for DB2 9

Brands by name

Popular brands