O'Reilly logo

Db2 for z/OS Utilities in Practice by Hendrik Mynhardt, Craig Friske

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Reorganizing Db2 data
REORG is a utility for the maintenance of application data and indexes. There are a number of reasons for running this utility, but some of the most common include keeping data organized for application performance, applying changes to the table space schema, formatting data rows, or redistributing and discarding of data rows. These functions are all expected to be done with little disruption of application availability. Here’s a more detailed list:
Materialization of schema changes:
 – Adding columns
 – Altering column data ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required