Skip to main content

   

IBM Redbooks  >  Information Management software




Redbooks Abstract

DB2 for z/OS and OS/390 Version 7 Using the Utilities Suite



Download PDF (3.7 MB)


Get AdobeĀ® ReaderĀ®


Additional Material


View as HTML


Tips for viewing


Order Hardcopy


Others who downloaded this book also downloaded ...

Abstract

IBM has continuously enhanced the functionality, performance, availability, and ease of use of DB2 Utilities. Starting with DB2 for MVS/ESA Version 4, the progression of changes has increased. DB2 for z/OS and OS/390 Version 7 introduces new functions and a new way of packaging the utilities.

This IBM Redbook is the result of a project dedicated to the new DB2 Version 7 Utilities Suite product. It provides information on introducing Wildcarding in operational scenarios, optimizing concurrent execution of utilities for a shorter night window, information for triggering utilities execution, and considerations on partitioning.

It also describes the new functions of LOAD (Cross Loader and Online RESUME) and REORG, as well as the new UNLOAD and COPYTOCOPY utilities, and it evaluates the impact of several options when using LOAD, REORG, RECOVER, COPY, and RUNSTATS.

This redbook concentrates on the recent enhancements. It implicitly assumes a basic level of familiarity with the utilities as provided by DB2 for OS/390 Version 6.

Table of Contents

Part1. Introduction
Chapter 1. Introduction
Part 2. Planning for DB2 Utilities
Chapter 2. Wildcarding and Templates
Chapter 3. Inline executions and parallelism
Chapter 4. Triggering and controlling executions
Chapter 5. Managing partitions
Part 3. Executing DB2 Utilities
Chapter 6. Loading data
Chapter 7. Reorganizing data
Chapter 8. Unloading data
Chapter 9. Recovering data
Chapter 10. Copying data
Chapter 11. Gathering statistics
Part 4. Appendixes
Appendix A. Tables for Real-Time Statistics
Appendix B. Sample JCL for copying Catalog and Directory objects
Appendix C. Creating a shadow catalog
Appendix D. UNICODE support
Appendix E. Additional material

Others who downloaded this publication also downloaded
Rational Application Developer V7 Programming Guide, SG24-7501-00
Introduction to the New Mainframe: z/OS Basics, SG24-6366-00
DB2 UDB for z/OS Version 8: Everything You Ever Wanted to Know, ... and More, SG24-6079-00


Profile

Publish Date
27 August 2001

Last Update
22 August 2005

Rating: rating
(based on 6 reviews)

Rate this book

Author(s)
Paolo Bruni
Marcelo Antonelli
Tom Crocker
Davy Goethals
Rama Naidoo
Bart Steegmans

ISBN
0738423246

IBM Form Number
SG24-6289-00

Number of pages
358