Method of Changing the Page Size of a DB2 Table Space While Keeping the Object Available

An article of manufacture comprising a computer usable medium having computer readable program code embodied therein which implements a method for updating object page size during reorganization of a table space in a database, said medium comprising modules implementing:

• (a) allocating a shadow data set for at least one object belonging to a first data set from said table space;
• (b) writing to a shadow control block corresponding to each of said allocated shadow data sets, a new page size value;
• said new page size value corresponding to said at least one object;
• (c) loading rows from said first data set of said table space into said allocated shadow data set;
• for each row loaded, reading each object corresponding to said loaded row from said table space and writing said read object to said allocated shadow data set;
• and
• (d) updating at least:
• said first data set of said table space with data from said shadow data set;
• a system catalog for said database with said new page size value;
• and at least one database control block with said new page size value;
• said at least one database control block corresponding to said first data set.

Reorganizing a designated object of a database that has exceeded a current page size by:

• a) writing to a larger page, rows added to said designated object;
• said writing based on recency information;
• b) permitting continual access to said designated object during said writing step;
• c) reading constituent rows from a plurality of existing pages corresponding to said designated object and subsequently copying said constituent rows to said larger page;
• and
• d) externalizing said designated object.

An article of manufacture comprising a computer usable medium having computer readable program code embodied therein which implements the reorganization of a designated object of a database that has exceeded a current page size;

• said medium comprising:
• a) writing to a larger page, rows added to said designated object;
• said writing based on recency information;
• b) permitting continual access to said designated object during said writing step;
• c) reading constituent rows from a plurality of existing pages corresponding to said designated object and subsequently copying said constituent rows to said larger page;
• and
• d) externalizing said designated object.