Automated DB2 Reorganization

MasterReorg® for DB2 on z/OS

Together with MasterCopy and MasterCopySet, MasterReorg is part of the MASTER-UTIL line, an automated software suite ensuring reorganizations, restores and backups.

The Problem

DB2 Tablespaces and Indexspaces rapidly become disorganized as you add, delete, and update data. You need to reorganize your data, but questions arise:

• Does your data need to be available 24/7?
• How to manage ERPs containing thousands of objects (SAP)?
• What are the most disorganized DB2 objects?
• How many reorganizations are possible during the time allotted by the user?

The MasterReorg solution

• MasterReorg is a program for automatically and selectively reorganizing DB2 objects in a controlled utility batch window
• MasterReorg selects the objects to be reorganized out of the thousands of objects
• MasterReorg runs only the reorganizations that can be completed within the allotted time
• MasterReorg automatically recovers the object if reorganization fails
• MasterReorg handles the complete reorganization process without batch analysis and without batch JCL generation

More details…

The advantages of MasterReorg

• The only tool of its kind on the market
• It optimizes use of utility batch windows by performing a maximum number of reorganizations within the allotted time
• It guarantees application performance by first reorganizing objects that are or will be penalizing performance
• Its online option ensures 24/7 data availability
• It analyzes the candidate objects very rapidly and efficiently (eliminating the need to run IBM Runstats)

We are prepared to demonstrate to you the excellent return on investment you will achieve with MasterReorg.