International Business Machines Corporation
ONLINE REORGANIZATION OF DATABASE TABLES WITH CONCURRENT UPDATES

Abstract:

In an approach to online reorganization of database tables with concurrent updates, a second table is created, where the second table has the same schema as the first table. A union of the first table and the second table is projected to create a view, where the view allows table data to be queried and modified while the database table reorganization is performed. Responsive to one or more running replication transactions completing, the database table reorganization is executed. Responsive to receiving a query, the query is allowed to access the view.