Abstract: An improved method and system for analyzing a database for determining a recommended reorganization of a database. In one embodiment, the method involves receiving a list of database records to be analyzed. Each analyzed database record which meets certain criteria may be designated as “qualified”. Identifying information for each qualified database record may be added to a detail array. The qualified database record information may be aggregated based on information in the detail array. The process of aggregating the qualified database record information may include constructing additional arrays (e.g., a roll-up array and a results tracking array). A reorganization strategy may be recommended based on the aggregated qualified database record information. The recommended reorganization strategy may be for an amount (e.g., none, full, partial) of reorganization of the database and a method (e.g., off-line, concurrent, on-line) of reorganization of the database.

Abstract: An improved method and system for on-line reorganization of an IMS database while allowing concurrent updates. In one embodiment, the method involves building and dynamically maintaining a map of free blocks in the IMS database. The user then provides a list of candidate database records to be analyzed. The physical characteristics of each database record on the list are then analyzed. Calculations are made to identify fragmented database records and the segments which contain fragmented boundary twin chains. A reorganization recommendation list is created for each database record on the list, including fragmented boundary twin chains. Each fragmented database record on the reorganization recommendation list is then reorganized.