Restartable method to reorganize DB2 tablespace records by determining new physical positions for the records prior to moving using a non sorting technic

A method for reorganizing a data table on a computer storage system, the data table being comprised of a plurality of data rows and having a related index, the method comprising the computer executed steps of:

• reading the index to determine the logical order of the data and the original location of the data and storing the ordering information and original location in logical sequence in an index buffer having entries for each data row;
• sequentially reading the data rows into a data buffer having an area for receiving the data and copying the length of each data row to a length buffer having entries for each data row, said length stored in said length buffer based on the original location of the data row;
• determining a new location for each data row by sequentially obtaining the row length of each data row from said length buffer using said original location and using said row length to develop said new location;
• saving said new location in a position corresponding to the data row original location;
• and
• sequentially sorting said data in a reorganized file by determining the original location of each data row in logical sequence, reading said data row from said data area using said original location and storing said read data row in said reorganized file.

A method for reorganizing a data table and a related index on a computer storage system, the data table being comprised of a plurality of data rows, the method comprising the computer executed steps of:

• reading the index to determine the logical order of the data and the original location of the data and storing the ordering information and original location in logical sequence in an index buffer having entries for each data row;
• sequentially reading the data rows into a data buffer having an area for receiving the data and copying the length of each data row to a length buffer having entries for each data row, said length stored in said length buffer based on the original location of the data row;
• determining a new location for each data row by sequentially obtaining the row length of each data row from said length buffer using said original location and using said row length to develop said new location;
• saving said new location in a position corresponding to the data row original location;
• sequentially storing the entries in said index buffer in a reorganized index file using the new locations;
• sequentially storing said data in a reorganized file by determining the original location of each data row in logical sequence, reading said data row from said data area using said original location and storing said read data row in said reorganized file.