DB2 9 for z/OS and Storage Management

An IBM Redbooks publication

Published 08 September 2010, updated 17 September 2010

cover image

ISBN-10: 0738434698
ISBN-13: 9780738434698
IBM Form #: SG24-7823-00
(436 pages)

More options

Rate and comment

Authors: Paolo Bruni, John Iczkovits, Hennie Mynhardt, Peter Zerbini


This IBM® Redbooks® publication can help you tailor and configure DFSMS constructs to be used in an IBM DB2® 9 for z/OS® environment. In addition, it provides a broad understanding of new disk architectures and their impact in DB2 data set management for large installations.

This book addresses both the DB2 administrator and the storage administrator. The DB2 administrator can find information about how to use DFSMS for managing DB2 data sets; the storage administrator can find information about the characteristics of DB2 data sets and how DB2 uses the disks. This book describes optimal use of disk storage functions in DB2 for z/OS environments that can best make productive use of the synergy with I/O subsystem on IBM System z®.

This book covers the following topics:
- Using SMS to manage DB2 catalog, log, data, indexes, image copies, archives, work files
- Taking advantage of IBM FlashCopy® for DB2 utilities, striping, copy pools
- Setting page sizes and using sliding allocation
- A description of PAV, MA, MIDAW, EF, EA, EAV, zHPF and why they are helpful
- Compressing data and the use disk and tape for large data sets
- Backup and restore, and remote copy services

Table of contents

Chapter 1. Introduction
Chapter 2. Disk and tape environment overview
Chapter 3. DB2 storage objects
Chapter 4. System managed DB2 data
Chapter 5. Implementing SMS for a DB2 environment
Chapter 6. DB2 I/O performance and monitoring
Chapter 7. DB2 I/O operations
Appendix A. Frequently asked questions

Follow IBM Redbooks

Follow IBM Redbooks