Modernize Your IBM DB2 for IBM z/OS Maintenance with Utility Autonomics

Modernize Your IBM DB2 for IBM z/OS Maintenance with Utility Autonomics

by Dean Brown, Carlos Gomes, Arthur Marais, Hennie Mynhardt
Released August 2015
Publisher(s): IBM Redbooks
ISBN: 9780738440897

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® for IBM z/OS® helps lower the cost of managing data by automating administration, increasing storage efficiency, improving performance, and simplifying the deployment of virtual appliances. By automating tasks such as memory allocation, storage management, and business policy maintenance, DB2 is able to perform many management tasks itself, freeing up Database Administrators to focus on new projects.

This IBM Redbooks® publication introduces autonomics for DB2 for z/OS. IBM provides several different components that, when combined, can create an autonomic database environment. All these respective components cover certain aspects of autonomics, which can collaborate into one coherent solution. In our evolution of autonomics and the need to move to smarter systems there has been a bigger drive to the concept of "Active" versus "Passive" autonomics. With the inclusion of the IBM Management Console for IMS™ and DB2 for z/OS and the Autonomics Director, it is now easier than ever to make that transition by leveraging the strength of the DB2 Utilities Solution Pack for z/OS all in one standardized and centralized interface.

This publication guides you through the business reasons for adopting autonomic solutions, and provides step-by-step guidance to implement these capabilities in your DB2 for z/OS configuration. This publication is of interest primarily to DB2 Database Administrators and DB2 Systems Programmers, and for anyone looking to understand the benefits of DB2 autonomic solutions.

Table of contents

  1. Front cover
  2. Notices
    1. Trademarks
  3. IBM Redbooks promotions
  4. Preface
    1. Authors
    2. Now you can become a published author, too!
    3. Comments welcome
    4. Stay connected to IBM Redbooks
  5. Chapter 1. The need for autonomics in database management
    1. 1.1 Overview
    2. 1.2 Why autonomics and modernization
      1. 1.2.1 The mainframe skills gap
      2. 1.2.2 What is autonomics and how it can solve business problems
    3. 1.3 DB2 autonomics
      1. 1.3.1 Autonomics Director for DB2
      2. 1.3.2 Maintenance windows
  6. Chapter 2. Product overview: Management Console and IBM DB2 UtilitiesSolution Pack
    1. 2.1 IBM Management Console for IMS and DB2 for z/OS
      1. 2.1.1 Architecture
      2. 2.1.2 Benefits
      3. 2.1.3 Plug-ins
    2. 2.2 DB2 Utilities Solution Pack
      1. 2.2.1 Why use Solution Packs?
      2. 2.2.2 Products overview
      3. 2.2.3 DB2 Automation Tool for z/OS
      4. 2.2.4 DB2 Utilities Enhancement Tool for z/OS
  7. Chapter 3. Business scenario and technical challenges
    1. 3.1 Obstacles to autonomic computing
    2. 3.2 The solution
    3. 3.3 A typical business case for DB2 Utility Autonomics
      1. 3.3.1 Challenges
      2. 3.3.2 Meeting these challenges
    4. 3.4 A typical traditional DB2 maintenance scenario: passive autonomics
    5. 3.5 The implementation process
      1. 3.5.1 Implementing an ACTIVE strategy for your DB2 maintenance tasks
    6. 3.6 Conclusion
  8. Chapter 4. Installing and configuring the DB2 Management Console
    1. 4.1 IBM software components required for the installation
      1. 4.1.1 IBM Installation Manager for z/OS V1.4.0 (5655-IMZ)
      2. 4.1.2 IBM Management Console for IMS and DB2 for z/OS, V1.1 (5655-TAC)
    2. 4.2 Using the IBM Tools Customizer to install the DB2 metadata
    3. 4.3 Installation and customization of the web server on z/OS
      1. 4.3.1 Setting up WLM for our installation
      2. 4.3.2 Creating the Unix System Services environment
  9. Chapter 5. IBM DB2 Utilities Solution Pack for z/OS configuration
    1. 5.1 Configuration overview
    2. 5.2 DB2 Automation Tool Customization
      1. 5.2.1 Tools Customizer steps for DB2 Automation Tool
      2. 5.2.2 More Automation Tool configuration steps
    3. 5.3 DB2 Utilities Enhancement Tool Customization configuration
      1. 5.3.1 Tools Customizer steps for DB2 Utilities Enhancement Tool
      2. 5.3.2 More Utilities Enhancement Tool configuration steps
  10. Chapter 6. Creating the autonomics infrastructure
    1. 6.1 Profiles
      1. 6.1.1 Object Profiles
      2. 6.1.2 Utility Profiles
      3. 6.1.3 Exception Profiles
      4. 6.1.4 Job Profiles
  11. Chapter 7. Configuring maintenance windows with Management Console and Autonomics Director
    1. 7.1 Introduction
    2. 7.2 Management Console for DB2
      1. 7.2.1 Defining a new maintenance window using Management Console
      2. 7.2.2 Adding a maintenance window to the schedule
      3. 7.2.3 Scheduling a maintenance window
    3. 7.3 Autonomics Console
      1. 7.3.1 Creating a maintenance window using Autonomics Console
      2. 7.3.2 Creating a time period using Autonomics Console
      3. 7.3.3 Scheduling a maintenance window using Autonomics Console
      4. 7.3.4 Define the base period
      5. 7.3.5 Define Job Profiles
  12. Chapter 8. Running it all together: Automation Tool, UET, Management Console, Autonomics Director 
    1. 8.1 Synergy with the DB2 Automation Tool
      1. 8.1.1 Building the process
      2. 8.1.2 Building the Build Job
    2. 8.2 Execution
      1. 8.2.1 Executing the Build Job
      2. 8.2.2 Executing the Autonomics Director
      3. 8.2.3 Autonomics Director and autonomics leading practices
  13. Chapter 9. Benefits and results of a fully autonomic solution
    1. 9.1 Business challenges
    2. 9.2 First steps
    3. 9.3 Second step
    4. 9.4 A more general problem: The aging workforce
    5. 9.5 Autonomics benefits
  14. Appendix A. Hints and tips
    1. DB2 Stored Procedures
    2. APF Authorization Failure in Automation Tool
    3. The Management Console and JCC packages
    4. Automation Tool and Management Console widgets
    5. What constitutes the Autonomics Director
    6. Management Console terms
    7. Management Console steps towards Active Autonomics
  15. Appendix B. DB2 Autonomics Director tables
    1. Concepts
    2. List of tables and their descriptions
  16. Back cover

Product information

  • Title: Modernize Your IBM DB2 for IBM z/OS Maintenance with Utility Autonomics
  • Author(s): Dean Brown, Carlos Gomes, Arthur Marais, Hennie Mynhardt
  • Release date: August 2015
  • Publisher(s): IBM Redbooks
  • ISBN: 9780738440897