Inventors:
Sally A. Gehring - Carlsbad CA, US
Dean L. Grover - Hollister CA, US
John T. Langley - San Jose CA, US
Assignee:
INTERNATIONAL BUSINESS MACHINES CORPORATION - Armonk NY
International Classification:
G06F 17/30
US Classification:
707640, 707803, 707769, 707E17005, 707E17007, 707E17014
Abstract:
A method for providing database reorganization statistics across timestamp recoveries, includes: appending statistical data for a database reorganization associated with a timestamp to a statistics file; determining that the database reorganization has resumed after a suspension; obtaining a resume timestamp; retrieving statistical data within the statistics file corresponding to the resume timestamp; and appending statistical data for the resumed database reorganization to the retrieved statistical data. Further raw statistical data for the resumed database reorganization are appended to the retrieved raw statistical data. When a unit of reorganization has committed or the resumed database reorganization has terminated, a statistics record including the retrieved raw statistical data and the further raw statistical data associated with another timestamp is created, and the statistics record is appended to the statistics file.