Redbook DB2 9 for z/OS: Using the Utilities Suite

John. Dee

Redbook DB2 9 for z/OS: Using the Utilities Suite

Hi DB2 user,

Here is a non-profit Blog about DB2 for z/OS (IBM mainframes):

Last update on Monday, January 4th 2010

IBM just published a draft version of a new Redbook, "DB2 9 for z/OS: Using the Utilities Suite, SG24-6289-01":

IBM continues to enhance the functionality, performance, availability, and ease of use of DB2 utilities.
This IBM Redbooks publication is the result of a project dedicated to the current DB2 Version 9 Utilities Suite product. It provides information on introducing the functions which help in setting up and invoking the utilities in operational scenarios, it shows how to optimize concurrent execution of utilities, collect information for triggering utilities execution, and considerations on partitioning.
It also describes the new functions provided by several utilities for SHARE LEVEL CHANGE execution which maximize availability and the exploitation of DFSMS constructs by the BACKUP and RESTORE SYSTEM utilities.
This book concentrates on the enhancements provided by DB2 UDB for z/OS Version 8 and DB2 for z/OS Version 9. It impicitly assumes a basic level of familiarity with the utilities as provided by DB2 for z/OS and OS/390 Version 7.

Table of Contents
Part 1. Introduction
Chapter 1. Introduction
Chapter 2. Backup and Restore utilities
Part 2. Planning for DB2 utilities
Chapter 3. Managing partitions
Chapter 4. Simplifying utilities with Wildcarding and Templates
Chapter 5. Performance via parallelism of executions
Chapter 6. Invoking and controlling executions
Chapter 7. Sort processing
Part 3. Executing DB2 utilities
Chapter 8. Loading and unloading data
Chapter 9. Reorganizing data
Chapter 10. Copying data
Chapter 11. Recoverying data
Chapter 12. Gathering statistics
Chapter 13. Verifying data consistency
Part 4. Managing and optimizing DB2 utilities
Chapter 14. Operational considerations
Chapter 15. DB2 Tools
Appendix A. Utilities related maintenance
Appendix B. Sample
Appendix C. Additional material

More information

First edition of this Redbook, published in August 2001 is still available:

- DB2 for z/OS and OS/390 Version 7 Using the Utilities Suite, SG24-6289-00




Your E-mail and More On-the-Go. Get Windows Live Hotmail Free.

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________ - with almost 150 IDUG Regional User Groups,
there is probably one near you!
Regional User Groups are your local connection to the Worldwide DB2 User Community

If you need to change settings, is the home of IDUG's DB2-L