Provided is a method for online reorganization and increasing the page
size of a DB2 object. A base table and related auxiliary table spaces are
reorganized concurrently via a database utility, DB2 REORG utility. The
database utility determines which auxiliary tables are related to the
base table and automatically includes their respective auxiliary table in
the same invocation of the utility. The reorganization is performed via
allocated shadow data sets; page size of the allocated shadow data sets
is dynamically updated during reorganization. The original data sets are
switched with the newly built shadow data sets, and DB2 catalog values
and control blocks are updated with new page size values.