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

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