Managing DB2 for z/OS Utilities with DB2 Tools Solution Packs

Managing DB2 for z/OS Utilities with DB2 Tools Solution Packs

Released July 2013
Publisher(s): IBM Redbooks
ISBN: 9780738438474

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Book description

IBM® DB2® Tools for z/OS® support and take advantage of the latest versions of DB2 for z/OS. These tools are integral for the administration of the DB2 for z/OS environment and for optimization of data performance. In addition, the IBM portfolio addresses additional client requirements in the areas of data governance and version upgrade acceleration.

Underlying the operation of any database management system are the utilities. With the number of database objects growing exponentially, managing utility jobs, meeting service level agreements (SLAs), and ensuring recoverability can be overwhelming. IBM offers DB2 Tools solution packs that assist in the DB2 utilities management process. Solution packs combine several products into a single consolidated solution providing everything necessary to ensure the execution of a set of database administration functions. The goals are to reduce the operational complexity and reduce cost.

The objective of this IBM Redbooks® publication is to document the added value in terms of productivity and performance for database administrators when using the IBM DB2 Utilities Solution Pack and the IBM DB2 Fast Copy Solution Pack. We show the functions of the tools provided by the solution packs as used in real-life scenarios and adopting utilities best practices.

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

Table of contents

  1. Front cover
  2. Tables
  3. Figures
  4. Examples
  5. Notices
    1. Trademarks
  6. Preface
    1. Authors
    2. Now you can become a published author, too!
    3. Comments welcome
    4. Stay connected to IBM Redbooks
  7. Summary of changes
    1. July 2013, Second Edition
  8. Part 1 Overview and background information
  9. Chapter 1. DB2 Tools solution packs
    1. 1.1 DB2 tools solution packs
    2. 1.2 DB2 Utilities and Fast Copy solution packs
      1. 1.2.1 Overview of the solution packs and the IBM Tools Customizer
      2. 1.2.2 Installing the base for solution packs
    3. 1.3 Installing the DB2 Utilities Solution Pack
      1. 1.3.1 DB2 Automation Component customization
      2. 1.3.2 DB2 High Performance Unload for z/OS
      3. 1.3.3 DB2 Sort for z/OS
      4. 1.3.4 DB2 Utilities Enhancement Tool
    4. 1.4 Installing the DB2 Fast Copy Solution Pack
      1. 1.4.1 DB2 Cloning Tool for z/OS
      2. 1.4.2 DB2 Recovery Expert for z/OS
  10. Chapter 2. FlashCopy technology
    1. 2.1 Operational environments
    2. 2.2 Basic concepts
      1. 2.2.1 Full volume copy
      2. 2.2.2 No copy option
    3. 2.3 FlashCopy in combination with other Copy Services
      1. 2.3.1 FlashCopy with Metro Mirror and Global Copy
      2. 2.3.2 Remote Pair FlashCopy
      3. 2.3.3 FlashCopy and Global Mirror
    4. 2.4 FlashCopy for z/OS data sets
    5. 2.5 DB2 for z/OS and FlashCopy
      1. 2.5.1 DB2 for z/OS and FlashCopy use
      2. 2.5.2 FlashCopy use by the DB2 COPY utility
      3. 2.5.3 DSNZPARMs for FlashCopy use by utilities
  11. Chapter 3. Backup and recovery concepts and functions
    1. 3.1 Image copy backups
    2. 3.2 DB2 recovery considerations
    3. 3.3 Introduction to recovery
    4. 3.4 Planning your recovery plan
    5. 3.5 Important topics about DB2 recovery
      1. 3.5.1 Understanding DB2 logs
      2. 3.5.2 DB2 utilities resources
      3. 3.5.3 DB2 system-level backup considerations
      4. 3.5.4 DB2 10 utilities enhancements for recovery
    6. 3.6 Choosing the best recovery for each situation
  12. Part 2 IBM DB2 Utilities Solution Pack
  13. Chapter 4. IBM DB2 High Performance Unload for z/OS
    1. 4.1 DB2 High Performance Unload technical overview
    2. 4.2 Using DB2 Administration Tool to generate a DB2 High Performance Unload job
    3. 4.3 DB2 High Performance Unload and FORMAT INTERNAL
      1. 4.3.1 Running DB2 High Performance Unload with format internal
    4. 4.4 DB2 High Performance Unload from FlashCopy
      1. 4.4.1 Running DB2 High Performance Unload from a FlashCopy
    5. 4.5 Generating DB2 High Performance Unload jobs from DB2 Automation Tool
  14. Chapter 5. IBM DB2 Sort for z/OS
    1. 5.1 Benefits of DB2 Sort
    2. 5.2 Sort capacity exceeded reduction
    3. 5.3 DB2 Sort OPTMODE parameter
    4. 5.4 The environment
      1. 5.4.1 DB2 Sort Spreadsheet Reporters
      2. 5.4.2 DB2 Utilities Sort Analysis Reporter
      3. 5.4.3 DB2 Sort performance
    5. 5.5 Unload and Load executions with DB2 Sort enabled and disabled
  15. Chapter 6. IBM DB2 Automation Tool for z/OS
    1. 6.1 DB2 Automation Tool: Profiles
      1. 6.1.1 DB2 Automation Tool Object Profiles
      2. 6.1.2 DB2 Automation Tool Utility Profiles
      3. 6.1.3 DB2 Automation Tool Exception Profiles
      4. 6.1.4 DB2 Automation Tool Job Profiles
    2. 6.2 Automation of REORG and backups using exception reporting
      1. 6.2.1 Automation of REORG using exception reporting
      2. 6.2.2 Controlling backups by using DB2 Automation Tool
      3. 6.2.3 Daily and weekly Utility Profiles
      4. 6.2.4 Image copy Exception Profile
      5. 6.2.5 Running the profiles
    3. 6.3 Automation of RUNSTATS by using autonomic statistics
    4. 6.4 DB2 administrative task scheduler
      1. 6.4.1 DB2 administrative task scheduler integration with DB2 Automation Tool
      2. 6.4.2 Using DB2 administrative task scheduler
    5. 6.5 Interfacing DSNACCOX with DB2 Automation Tool
      1. 6.5.1 DSNACCOX recommendations
      2. 6.5.2 REXX procedure ADMCOX
      3. 6.5.3 Building the DSNACCOX Exception Profile
      4. 6.5.4 AUTOTEST stored procedure
    6. 6.6 DB2 Automation Tool and CHECK DATA
  16. Chapter 7. IBM DB2 Utilities Enhancement Tool for z/OS
    1. 7.1 How the Utility Monitor works
      1. 7.1.1 A look inside the utility governance policy
      2. 7.1.2 The policy rules are used to invoke the Utility Monitor
    2. 7.2 Enforce the use or disuse of utility syntax
    3. 7.3 Allow or disallow users from executing utilities
    4. 7.4 Change the severity of a DB2 message
    5. 7.5 Suppress repetitive messages in utility SYSPRINT
    6. 7.6 Use the Utility Monitor for auditing purposes or trend analysis
    7. 7.7 Accelerate LOADs with PRESORT
    8. 7.8 Avoid contention or delays during your maintenance window
  17. Part 3 IBM DB2 Fast Copy Solution Pack
  18. Chapter 8. IBM DB2 Recovery Expert for z/OS
    1. 8.1 DB2 Recovery Expert
      1. 8.1.1 What is new in DB2 Recovery Expert V3.1
      2. 8.1.2 Base architecture
      3. 8.1.3 DB2 system, object, and application recovery
      4. 8.1.4 System level backup
    2. 8.2 System level backup scenario
    3. 8.3 System level restore
    4. 8.4 Object recovery
    5. 8.5 Log-based dropped object recovery using web interface
  19. Chapter 9. IBM DB2 Cloning Tool for z/OS
    1. 9.1 DB2 Cloning Tool cloning types
      1. 9.1.1 Why cloning
      2. 9.1.2 Our cloning test environment
    2. 9.2 General considerations for cloning
    3. 9.3 Support jobs, commands, and tools
      1. 9.3.1 DB2 Cloning Tool jobs
      2. 9.3.2 DB2 tasks
      3. 9.3.3 IBM DB2 Recovery Expert Tool for z/OS
      4. 9.3.4 System commands
    4. 9.4 DB2 subsystem level cloning
      1. 9.4.1 Considerations for system level cloning
    5. 9.5 Subsystem cloning with system level backup
      1. 9.5.1 Validating system level backup for cloning
      2. 9.5.2 Using the ISPF dialog to prepare a clone from a system level backup
      3. 9.5.3 System level backup jobs
      4. 9.5.4 Post-cloning steps
    6. 9.6 Subsystem level cloning using the stored procedure
      1. 9.6.1 Stored procedure process
      2. 9.6.2 Stored procedure parameters
      3. 9.6.3 Invoke the stored procedure
    7. 9.7 Cloning at the table space level
      1. 9.7.1 Key features
      2. 9.7.2 Refreshing DB2 objects without DB2 Cloning Tool
      3. 9.7.3 Our table space cloning scenario
      4. 9.7.4 Target Data Definition Language (DDL)
      5. 9.7.5 Renaming table spaces and index spaces
      6. 9.7.6 Object status
      7. 9.7.7 Prerequisite to table space cloning
      8. 9.7.8 Tablespace cloning with the ISPF dialog
      9. 9.7.9 Setting up the target job
      10. 9.7.10 Setting up the source job
      11. 9.7.11 Running the clone
      12. 9.7.12 Source job
      13. 9.7.13 Target job
      14. 9.7.14 Summary of the table space clone process
      15. 9.7.15 LOG APPLY and FUZZY-COPY
    8. 9.8 Dealing with special objects
      1. 9.8.1 Identity columns
      2. 9.8.2 Partition-by-growth (PBG) table spaces
      3. 9.8.3 Large objects (LOBs)
      4. 9.8.4 Table space reordered row format
      5. 9.8.5 LONGVAR versus VARCHAR
      6. 9.8.6 Just VARCHAR
      7. 9.8.7 Considerations for objects created by using DEFINE NO
      8. 9.8.8 Clone tables
      9. 9.8.9 Job templates
    9. 9.9 Using DB2 Cloning Tool with the DB2 Administration Tool
    10. 9.10 Runtime repository
  20. Part 4 Appendixes
  21. Appendix A. Test environment
    1. A.1 Our test environment
    2. A.2 Stored procedures workload
    3. A.3 Accessing the tools
  22. Appendix B. DSNZPARMs and general settings
    1. B.1 DB2 DSNZPARM setup
  23. Appendix C. Additional material
    1. Locating the web material
    2. Using the web material
  24. Related publications
    1. IBM Redbooks
    2. Other publications
    3. Online resources
    4. Help from IBM
  25. Back cover

Product information

  • Title: Managing DB2 for z/OS Utilities with DB2 Tools Solution Packs
  • Author(s):
  • Release date: July 2013
  • Publisher(s): IBM Redbooks
  • ISBN: 9780738438474