DB2 9 for z/OS and Storage Management

An IBM Redbooks publication




Abstract

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




Profile

Publish Date
08 September 2010

Last Update
17 September 2010


Rating:
(based on 2 reviews)


Author(s)

ISBN-10
0738434698

ISBN-13
9780738434698

IBM Form Number
SG24-7823-00

Number of pages
436