Method of changing the page size of a DB2 table space while keeping the object available

Provided is a method for online reorganization and increasing the page size of a DB 2 object. A base table and related auxiliary table spaces are reorganized concurrently via a database utility, DB 2 REORG utility. The database utility determines which auxiliary tables are related to the base table...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Hauptverfasser: FRANKLIN WILLIAM JAMES, BOWER FRANK DARL, TENG JAMES ZUIA, LYLE JOHN RICHARD, LEUNG SAIYIN, YOTHERS JAY A, CORNWELL KARELLE LYNNE, CORNFORD ROY JAMES
Format: Patent
Sprache:eng
Schlagworte:
Online-Zugang:Volltext bestellen
Tags: Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
Beschreibung
Zusammenfassung:Provided is a method for online reorganization and increasing the page size of a DB 2 object. A base table and related auxiliary table spaces are reorganized concurrently via a database utility, DB 2 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 DB 2 catalog values and control blocks are updated with new page size values.