manualshive.com logo in svg

IBM DB2 9, Руководство по планированию

Поделиться
Скачать
IBM DB2 9 Скачать руководство пользователя страница 24

               509529      DB2 Changing the  DB Host
              513750      DB2 Data Sharing Topology
              390016      DB2/390  BW: DB Settings and Performance
              758550      DB2 System Parameter Check  (DB16)
               686905     History of statement cache statistics in  ST04
               956517     DB2 for z/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 configuration problem
               915482     DB2 for z/OS: Automating  DB failover 
            

              

Copyright 2006  

IBM Solutions Technical Sales (STS)

                    12/18/2007Page 24 of 51  

12/18/2007 
Planning and Preparation Guide for SAP NetWeaver Version 6.40: z/OS Implementation

Содержание DB2 9

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 28: ...6432 IPCSHMMPAGES 524287 IPCSHMNSEGS 100 IPCSEMNIDS 4096 IPCSHMNIDS 4096 IPCSEMNSEMS 32767 IPCSEMNOPS 32767 MAXMMAPAREA 4096 MAXCORESIZE 2147483647 MAXASSIZE 2147483647 MAXCPUTIME 2147483647 MAXSHAREP...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 38: ...TIMELEN 0 END Copyright 2006 IBM Solutions Technical Sales STS 12 18 2007Page 38 of 51 12 18 2007 Planning and Preparation Guide for SAP NetWeaver Version 6 40 z OS Implementation...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Отзывы:

Нет отзывов

Бренды по названию

Популярные бренды

Загрузить еще бренды