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.

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