Online/Defrag Record Analysis
The Record Analysis is an independent component of Online/Defrag that precedes a record mode reorganization.
- Online/Defrag Extractor and Recommendation Selector
The Online/Defrag Extractor and Recommendation Selector process reads the database and produces files that are used to maximize record or scan mode reorganizations. The process calculates parameters that will result in the greatest reduction of I/O activity (buffer searches). - Online/Defrag Analyzer
The Online/Defrag Analyzer receives the output data sets from the Online/Defrag Extractor and Recommendation Selector process and analyzes each record in the data set to determine candidacy for reorganization.
The following figure shows the system flow for the Record Analysis.
The Online/Defrag Record Analysis uses the following components and processes:
Component or process | Description |
|---|---|
Online/Defrag Extractor and Recommendation Selector | The Extractor gathers information required to analyze database records and produces an output data set. The Recommendation Selector uses the Extractor output and the MINREC keyword to calculate the combination of MBI and BIPF values that will result in the greatest reduction of I/O activity. The administrator defines the minimum number of records to be reorganized. The Recommendation Selector creates three output data sets: reports, an output data set directed to Online/Defrag Analyzer (ANALYZE command), and an output data set directed to Online/Defrag (OREORG command). |
Output data set, OREORG | The output data set with the OREORG command is input to the Online/Defrag function. |
Output data set, ANALYZE | The output data set with the ANALYZE command is input to the Online/Defrag Analyzer for record mode reorganizations. The Online/Defrag Analyzer verifies that the Recommendation Selector values for the MBI and BIPF keywords will result in the greatest reduction of I/O activity. |
Online/Defrag Analyzer | Online/Defrag Analyzer uses the DBD, BIPF, MBI, and FSPF keywords to identify records that are candidates for reorganization. Online/Defrag Analyzer produces the key list data set that is passed to the Online/Defrag job. |
Key list data set | The key list data set is the table of record keys that Online/Defrag Analyzer generates when MODE(RECORD) is specified. The table identifies records that are candidates for reorganization. The key list data set can be used as input to the Online/Defrag job. |
Online/Defrag | Online/Defrag is the online reorganization job. |
Keywords | Keywords control the extraction, recommendation selection, analysis, and reorganization. |
Reports | Online/Defrag Extractor and Recommendation Selector, Online/Defrag Analyzer, and Online/Defrag automatically generate reports. |
This section contains the following topics:
Related topic