DB2 Utilities

DB2 utilities can be viewed in two general categories: those that execute within the subsystem (on line) and those that are standalone which run outside the subsystem (off line). The following list shows the activities performed by the utilities and where they are discussed in detail in this book:

  • Loading data (Chapter 7–Maintaining Data)

  • Reorganizing data (Chapter 7–Maintaining Data)

  • Recovery data and indexes (Chapter 8–Database Recovery)

  • Rebuilding indexes (Chapter 8–Database Recovery)

  • Gathering statistics (Chapter 7–Maintaining Data)

  • Quiescing data (Chapter 8–Database Recovery)

  • Repairing data (Chapter 7–Maintaining Data)

Executing Utilities

The most common way to execute the DB2 utilities is the creation of JCL with the appropriate ...

Get DB2® Universal Database for OS/390® Version 7.1 Certification Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial