Patent №
US 8,639,657
Granted
2014-01-28
Filed 2008
Owner
INTERNATIONAL BUSINESS MACHINES CORPORATION
Lab
AI components
3
ml · kr · hardware
Assignment
Recorded
Dataset
AIPD
2023_r1 edition
Application
12260330
The present invention generally relates to reorganization of table-based data objects. In a typical embodiment, the present invention utilizes SQL based scripts to run and manage online “reorgs” on DB2® table data. Such reorgs can occur synchronously or asynchronously and typically include: defragmenting the data objects to reclaim free space; sorting the data objects according to an index; and/or eliminating overflow rows in order to improve data objects access performance. Also under the present invention, information pertaining to the reorg (e.g., status) will be collected. DB2® tables can be used to drive, control, manage and track the reorganization operation. Still yet, “runstat” maintenance can be performed against data objects affected by the reorgs.
AI classification
Ownership
INTERNATIONAL BUSINESS MACHINES CORPORATION
assignment · 217560213
Assignors
WANGELIEN, GEORGE G.
On an employer assignment, the assignors are typically the inventors.