Abstract
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
Chapter 1. The need for autonomics in database management
Chapter 2. Product overview: Management Console and IBM DB2 Utilities Solution Pack
Chapter 3. Business scenario and technical challenges
Chapter 4. Installing and configuring the DB2 Management Console
Chapter 5. IBM DB2 Utilities Solution Pack for z/OS configuration
Chapter 6. Creating the autonomics infrastructure
Chapter 7. Configuring maintenance windows with Management Console and Autonomics Director
Chapter 8. Running it all together: Automation Tool, UET, Management Console, Autonomics Director
Chapter 9. Benefits and results of a fully autonomic solution
Appendix A. Hints and tips
Appendix B. DB2 Autonomics Director tables