Skip to main content

DB2 9 for z/OS and Storage Management

An IBM Redbooks publication

Note: This is publication is now archived. For reference only.


Published on 09 September 2010, updated 17 September 2010

  1. .EPUB (3.3 MB)
  2. .PDF (9.0 MB)

Google Play Books

Share this page:   

ISBN-10: 0738434698
ISBN-13: 9780738434698
IBM Form #: SG24-7823-00

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

    menu icon


    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


    Others who read this also read