DB2mag Spring and Summer 2010

Hi DB2 user,

Spring and Summer 2010 issues of DB2mag are available on line:

- DB2mag Summer 2010
- DB2mag Spring 2010

- DB2mag Archives (since Spring 2009)
- DB2mag Archives (Winter 1996-Spring 2009)

Note: DB2mag became IBMDatabasemag and then IBM Data Management magazine.


- DB2 10 for z/OS
More details emerge about new features that can slash CPU costs.
by Dave Beulke

- When Data Wears Out Its Welcome
Are cold data records gumming up the performance of your servers?
by Robert Catterall

- Reducing Conversations with DB2 for z/OS: Part 2
More tried-and-true basics and a few new bells and whistles.
by Bonnie Baker



- Maintenance Makes Money
Five ways to cut database costs - just by paying attention.
by Sheryl Larsen

- Real-Life DB2 Superheroes
IBM puts DB2 powers on display at the IDUG conference.
by David Beulke

- You Want to Govern What?
A database guy discovers data governance.
by Robert Catterall

- Reducing Conversations with DB2 for z/OS: Part 3
Different ways of thinking about ordinary things.
by Bonnie Baker



Regards,

DB2usa.

Redbook DB2 9 for z/OS and Storage Management

Hi DB2 User,

IBM just published a draft version of a new Redbook, "DB2 9 for z/OS and Storage Management, SG24-7823-00":
http://www.redbooks.ibm.com/Redbooks.nsf/RedpieceAbstracts/sg247823.html?Open

Abstract
This IBM Redbooks publication will help you tailor and configure DFSMS constructs to be used in a 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 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. We describe optimal use of disk storage functions in DB2 for z/OS environments which can best exploit the synergy with I/O subsystem on System z.

The addressed topics include the following:
- Using SMS to manage DB2 catalog, log, data, indexes, image copies, archives, workfiles.
- Taking advantage of FlashCopy for DB2 utilities, striping, copypools.
- Setting page sizes and using sliding allocation.
- PAV, MA, MIDAW, EF, EA, EAV. What they are and why they are good for you.
- Compressing data and indexes and the use disk and tape for very large data sets.
- Backup and Restore, and remote copy services recommendations.

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



Regards,

DB2usa.