Patent ID: 7447717
Filing Date: 2008-11-04
Classification: G06F,Y10S

Abstract:
1. A method for updating object page size during reorganization of a table space in a database comprising the steps of: (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 page size value larger than a page size value to be allocated; said larger 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 larger page size value; and at least one database control block with said larger page size value; said at least one database control block corresponding to said first data set.