SAP on DB2 Universal Database for OS/390 and z/OS: Multiple Components in One Database (MCOD)

Book description

The Multiple Components in One Database (MCOD) feature of SAP enables a reduction in the number of DB2 systems that need to be installed and maintained. This significantly simplifies overall database administration and is considered one of the major DB2 competitive advantages.
This IBM Redbooks publication will help systems administrators, database administrators, managers, and operation staff to plan, implement, and administer an SAP MCOD landscape with DB2 Universal Database (UDB) for OS/390 and z/OS as the database management system.
We describe how to merge existing systems into a single DB2 subsystem. Two different methods are developed, each of them addressing different needs. For small-to-medium SAP systems where high availability is not a requirement, we explain how to use SAP tools. For large systems, where the down time needed by SAP standard procedures is not acceptable, we document a technique to merge SAP components without moving the data.
We also provide a cloning procedure using the Control Center. We show how to clone one component out of an MCOD landscape. We address the backup and recovery implications in an MCOD environment, to help database administrators plan accordingly. We also describe how to set up and use the Computer Center Management System (CCMS) in an MCOD landscape.

Please note that the additional material referenced in the text is not available from IBM.

Table of contents

  1. Figures
  2. Notices
    1. Trademarks
  3. Preface
    1. The team that wrote this redbook
    2. Become a published author
    3. Comments welcome
  4. Chapter 1: MCOD in a DB2 UDB for OS/390 and z/OS environment
    1. Introduction
      1. Motivation
      2. Benefits
      3. Drawbacks
      4. Availability
    2. Technical realization
      1. General implementation
      2. DB2-specific modifications
      3. Independence of components
      4. Implementation
    3. Setup options
      1. Basic setup considerations
      2. Non-data sharing DB2
      3. Data sharing DB2
  5. Chapter 2: Planning for an MCOD landscape
    1. Planning for MCOD
      1. Keep things as separate as possible
      2. Size of the DB2 subsystem
      3. Number of SAP systems in the MCOD landscape
      4. Bufferpool tuning
      5. Recovery of the DB2 subsystem
      6. Resources for daily tasks
      7. License key
      8. Checklist
    2. Install directly
    3. Merging two systems
      1. Three methods of merging
      2. Additional tasks
      3. Checklist for merging
    4. Our system configuration
  6. Chapter 3: MCOD installation and merge using SAP tools
    1. Introduction
      1. SAP Basis Releases 4.6C and 4.6D
      2. SAP Basis Releases 6.10 and later
    2. Installing a new component
      1. SAP Basis Releases 4.6C and 4.6D
      2. SAP Basis Releases 6.10 and later
    3. Merging components into an MCOD landscape
      1. SAP Basis Releases 4.6C and 4.6D
      2. SAP Basis Release 6.10 and later
    4. Steps after installation or merge
    5. Minimizing migration down time
      1. Incremental migration
      2. Merging without moving the data
  7. Chapter 4: Merging SAP components without moving data
    1. Considerations for using this procedure
      1. Reasons for choosing the merge in place procedure
      2. Limitations
      3. Tools we used
    2. Planning considerations
      1. Decide on source and target DB2 subsystem
      2. Decide on naming conventions for merged system
      3. System availability issues
      4. System backup and recovery issues
      5. Hardware-based backup options
      6. Merge in place procedure checklist
    3. Merge in place scenario
    4. Preparation steps
      1. Source: Create full backup of source system
      2. Target: Create full backup of catalog and directory of target
      3. Source: Redefine empty tablespaces as DEFINE NO in source
      4. Source: Reorganize tablespaces
      5. Source and Target: Create and populate metadata tables
      6. Source and Target: Define source objects in target system
      7. Target: Update metadata tables
      8. Target: Stop newly created databases
      9. Target: Prepare RUNSTATS JCL
    5. Migration steps
      1. Source: Stop all update activity on source system
      2. Source: Perform full backup of source DB2 subsystem
      3. Source: Start source databases for UT access
      4. Source: Execute REPAIR on page set header pages
      5. Source: Stop source DB2 subsystem
      6. Target: Delete target data sets and rename source data sets
      7. Target: Start target databases in target system
      8. Target: Execute REPAIR LEVELID on tablespaces and indexes
      9. Cold start target system (optional)
      10. Target: Execute RUNSTATS
      11. Target: Perform IMAGE COPY
      12. Configure SAP application server
    6. Post-migration steps
      1. Target: Verify access to objects using RSDB2MAS (optional)
      2. Target: Alter the space allocations for TS and IX (optional)
  8. Chapter 5: Cloning one component out of an MCOD landscape
    1. MCOD cloning: Just another homogeneous system copy
      1. Homogeneous system copy (HSC)
      2. MCOD cloning
      3. Control Center support for HSC and MCOD cloning
    2. Cloning scenario
    3. Using the Control Center cloning wizard
      1. System requirements
      2. Skill requirements
      3. Prepare to create a cloning session
      4. Running the Control Center cloning wizard (1/4)
      5. Running the Control Center cloning wizard (2/4)
      6. Running the Control Center cloning wizard (3/4)
      7. Running the Control Center cloning wizard (4/4)
      8. Prepare for submitting the generated JCL
      9. XMAP member and MCOD cloning
      10. When do you have to regenerate JCL
      11. Running the generated JCL
      12. Additional considerations (1/2)
      13. Additional considerations (2/2)
  9. Chapter 6: PPT recovery of one system in an MCOD landscape
    1. Different reasons for MCOD usage
      1. Use of SAP MCOD for consistency
      2. Use of SAP MCOD for consolidation
    2. Recovery scenarios
      1. Determination of the scope of SAP components affected
      2. Work with the application owners
      3. Determining if a DB2 recovery is needed
    3. Scenario: Recovery of one component
      1. Description of the cause of error
      2. Determination of recovery steps
    4. Additional considerations
      1. Application of scenario to other applications
      2. Considerations for multiple SAP component recovery
      3. Testing in advance
  10. Chapter 7: Computer Center Management System (CCMS) and MCOD
    1. Setup of CCMS in an MCOD landscape
      1. Required patches
      2. Setup of SAP collector tools saposcol and rfcoscol
      3. Central DBA planning calendar
    2. MCOD enhancements
      1. Tables and indexes monitor (transaction DB02)
      2. Central DBA planning calendar (transaction DB13C)
      3. DBA planning calendar (transaction DB13): Backup
      4. Backup monitor (transaction DB12)
      5. CCMS monitor set (transaction RZ20)
      6. Database performance analysis (transaction ST04) (1/2)
      7. Database performance analysis (transaction ST04) (2/2)
  11. Appendix A: Database layout
    1. Overview
      1. General remarks
      2. R/3 Releases 3.0F, 3.1H, 3.1I, and 4.0B
      3. R/3 Releases 4.5A and 4.5B
      4. Basis Releases 4.6B, 4.6C, and 4.6D
      5. Basis Releases 6.10 and 6.20
    2. Rename procedure
      1. General procedure
      2. Mixed layouts
  12. Appendix B: Merge in place: Working with metadata tables
    1. Creating metadata tables
      1. DDL for creation of ZMCODDB
      2. DDL for creation of ZMCOD_STOGROUP
      3. DDL for creation of ZMCOD_DATABASE
      4. DDL for creation of ZMCOD_TABLESPACE
      5. DDL for creation of ZMCOD_TABLES
      6. DDL for creation of ZMCOD_INDEXES
    2. Populating metadata tables
      1. SETUPSTG
      2. SETUPDB
      3. SETUPTS
      4. SETUPTAB
      5. SETUPIX
      6. JCL to run the population REXX procedures
    3. Moving metadata tables across systems
      1. JCL to unload metadata tables on the source system
      2. JCL to load metadata tables into the target system
      3. JCL to reset copy pending status on tablespaces
    4. Working with metadata tables
      1. DUPLICDB
      2. JCL to run the duplicate resolution REXX procedure
    5. Updating metadata tables
      1. POSTDDL
      2. POSTDDL2
      3. JCL used to run the update REXX procedures
  13. Appendix C: Merge in place: Defining source objects in target system
    1. Generating DDL using DB2 Admin
      1. Invoking DB2 Admin
      2. JCLGEN (1/2)
      3. JCLGEN (2/2)
      4. JCLGENDB
      5. JCLGENTS
      6. JCLGENTB
      7. JCLGENIX
      8. JCL to run generation REXX procedure and submit the generated JCL
    2. Tailoring the output from DB2 Admin
      1. TAILORTS
      2. TAILORIX
      3. TAILORTB
      4. JCL to run the tailoring REXX procedures
    3. Sample DDL for creating objects
    4. Using filler tablespaces to reserve OBIDs
  14. Appendix D: Merge in place: Migrating the data
    1. Running the migration procedures
      1. PDS libraries used
      2. Input parameters for all migration procedures
    2. Extracting information from the metadata tables
      1. $ZMCDBSR
      2. $ZMCINSR
      3. $ZMCTSSR
      4. PQUERYTB
    3. Issuing DB2 START and STOP DATABASE commands
      1. PDSNDBST
    4. Executing REPAIR on page set header pages
      1. PREPTSOB
      2. PREPINOB
    5. Deleting created target data sets and renaming source data sets
      1. PVSATSDE
      2. PVSAINDE
      3. PVSATSAL
      4. PVSAINAL
    6. Executing REPAIR LEVELID on tablespaces and indexes
      1. PREPTSLV
      2. PREPINLV
    7. Generating DDL for views
      1. $IBMVIST
      2. PCREATVI
    8. Generating DDL for altering object sizes
      1. $IBMTSSR
      2. $IBMINSR
      3. PTEPTSAL
      4. PTEPINAL
  15. Appendix E: Additional material
    1. Locating the Web material
    2. Using the Web material
      1. How to use the Web material
  16. Abbreviations and acronyms
  17. Related publications
    1. IBM Redbooks
      1. Other References
      2. SAP Notes
    2. Referenced Web sites
    3. How to get IBM Redbooks
      1. IBM Redbooks collections
  18. Index (1/2)
  19. Index (2/2)
  20. Back cover

Product information

  • Title: SAP on DB2 Universal Database for OS/390 and z/OS: Multiple Components in One Database (MCOD)
  • Author(s): Mike Ebbers, Florence Dubois, Kellie Bohlsen, Tim Bohlsen, Bernd Kohler, Gert Ruland
  • Release date: February 2003
  • Publisher(s): IBM Redbooks
  • ISBN: None