System and method for analyzing a database for on-line reorganization

A system for analyzing a database for determining an approach for reorganization of the database, the system comprising:

• a network;
• a CPU coupled to the network;
• a memory coupled to the CPU which stores an INS database;
• a system memory coupled to the CPU, wherein the system memory stores one or more computer programs executable by the CPU;
• wherein the computer programs are executable to:
• (a) receive a list of database records to be analyzed;
• (b) analyze each database record on the list wherein updates to the database are performed while the analyzing occurs;
• (c) designate as “qualified” each analyzed database record on the list which meets certain criteria;
• (d) add identifying information for each qualified database record having a given set of qualifying control variables to a detail array, each detail array entry comprising a count element a blocks improved element and a total size of database record element;
• (e) repeat (b) through (d) until each database record on the list is analyzed, including incrementing the count element the blocks improved element and the total size of database record element of a given detail array entry when a second or subsequent occurrence of the values for the given set of qualifying control variables is found;
• (f) aggregate qualified database record information based on information in the detail array;
• and
• (g) recommend a reorganization strategy based on the aggregated qualified database record information.

A carrier medium which stores program instructions for analyzing a database for determining an approach for reorganization of the database, wherein the program instructions are executable to implement:

• (a) receiving a list of database records to be analyzed;
• (b) analyzing each database record on the list wherein updates to the database are performed while the analyzing occurs;
• (c) designating as “qualified” each analyzed database record on the list which meets certain criteria;
• (d) adding identifying information for each qualified database record having a given set of qualifying control variables to a detail array, each detail array entry comprising a count element, a blocks improved element and a total size of database record element;
• (e) repeating (b) Through (d) until each database record on the list is analyzed, wherein said act of repeating includes incrementing the count element, the blocks improved element and the total size of database record element of a given detail array entry when a second or subsequent occurrence of the values for the given set of qualifying control variables is found;
• (f) aggregating qualified database record information based on information in the detail array;
• and
• (g) recommending a reorganization strategy based on the aggregated qualified database record information.