Tasks that REORG PLUS performs

Resources

• Analyzes resources for the specific reorganization

• Provides data about resource requirements

• Optionally offloads eligible processing to an IBM z Integrated Information Processor (zIIP)

• Optionally allocates sort work files, index work files, unload data files, archive files, and copy files dynamically

Partitions

• Allows select and delete operations during a partial or full reorganization

• Rebalances partitions for all access levels, including SHRLEVEL CHANGE

Conditional reorganizations

Performance

• Provides data for fine-tuning reorganization performance

• For an additional performance gain, offers an optional single processing phase

• Allows multitasking that is not limited by the number of CPUs

Accessibility

• Optionally allows the objects that you are reorganizing to be available in read-only (RO) status during unload and reload processing

• Offers a nondestructive reorganization process, meaning that the objects that you are reorganizing remain intact throughout the reorganization

• Reclaims space that dropped tables and deleted rows occupied

• Offers online reorganization by using SHRLEVEL CHANGE, allowing applications to have read-write (RW) access during most of the reorganization processing

• For a SHRLEVEL CHANGE reorganization, allows you to dynamically change the REORG command by using the XBM Utility Monitor or the MVS console

Rebuilding objects and data

• Removes row indirection

• Optionally purges unwanted or out-of-date information and can write this data to an archive data set (for all types of reorganizations)

• Optionally updates column values to a specified constant value

• Reorders out-of-cluster-order rows in single and multi-table table spaces by table and clustering key or by clustering key only

• Rebuilds associated indexes

• Restores PCTFREE and FREEPAGE space in table spaces and indexes

• Adds NULL or DEFAULT values to short rows after a table is altered to add new columns

• Optionally reorganizes without reclustering rows

• Optionally deletes and redefines user-defined data sets and data sets defined in Db2 storage groups as part of the reorganization

Copies

• With a self-contained copy function, produces image copies or DSN1COPY-type copies concurrently with the reorganization

• Optionally dynamically allocates the full and incremental image copy data sets

• Optionally produces inline image copies as it reloads your tables

Statistics and reports

• Produces a statistics report

• Optionally updates statistics in the DASD MANAGER PLUS statistics tables

• Optionally updates statistics in Db2 catalog tables

• Optionally maintains historical records of all REORG PLUS activities

• Resets real-time statistics and timestamp values (in both DSNRTSDB and Db2 memory)

• Optionally provides a report listing the ALTER statements for the limit-key updates that REORG PLUS makes during partition rebalancing

Restart and recovery

• Provides restart capabilities

• Optionally recovers from an abnormal termination

• Lists the highest Db2 log relative byte address (RBA) or log record sequence number (LRSN) for the table space to facilitate recovery if the reorganization does not complete

User exits

Provides user exit points that allow you to:

• Provide user-defined variables that you can use to construct data set name patterns for dynamically allocated files

• Automatically resize Db2 VSAM objects

• Reorder your storage group volumes or use a subset of them

• Selectively specify REDEFINE NO for an object

• Bypass the insert into BMCHIST and give you dynamic control over updates to BMCHIST, BMCSTATS, real-time statistics, and UPDATEDB2STATS at termination

• Create (and drop after successful DSNUTILB completion) mapping objects for use when invoking DSNUTILB