Storage Management with DB2 for OS/390

This redbook will help you tailor and configure DFSMS constructs to be used in a DB2 for OS/390 environment. In addition, this redbook provides a broad understanding of new disk architectures and their impact in DB2 data set management for large installations.

This book addresses both the storage administrator and the DB2 administrator. The DB2 administrator will find information on how to use DFSMS for managing DB2’s data sets. The storage administrator will find information on the characteristics of DB2 data sets and how DB2 uses the disks.

After introducing the overall topics of this book, we provide a summary of our conclusions. This will be especially useful for readers responsible for organizing and managing DB2 data in an installation.

Chapter 1. Introduction
Chapter 2. Summary of Considerations
Chapter 3. DB2 Storage Objects
Chapter 4. System Managed Storage Concepts and Components
Chapter 5. Storage Management with DFSMS
Chapter 6. Managing DB2 Databases with SMS
Chapter 7. Managing DB2 Recovery Data Sets with SMS
Chapter 8. Converting DB2 to Systems Managed Storage
Chapter 9. Disk Environment Overview
Chapter 10. DB2 I/O Operations
Chapter 11. I/O Performance and Monitoring Tools
Appendix A. Test Cases for DB2 Table Space Data Sets
Appendix B. Test Cases for DB2 Recovery Data Sets
Appendix C. DB2 PM Accounting Trace Report
Appendix D. DB2 PM Statistics Report

Publish Date
21 September 1999

Rating: Not yet rated

Rate this book

Author(s)
Paolo Bruni
Hans Duerr
Daniel Leplaideur
Steve Wintle

ISBN
0738414204

IBM Form Number
SG24-5462-00

Number of pages
272