Patents by Inventor Roy J. Comford

Roy J. Comford has filed for patents to protect the following inventions. This listing includes patent applications that are pending as well as patents that have already been granted by the United States Patent and Trademark Office (USPTO).

  • Method of changing the page size of a DB2 table space while keeping the object available
    Patent number: 8306978
    Abstract: 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.
    Type: Grant
    Filed: July 11, 2008
    Date of Patent: November 6, 2012
    Assignee: International Business Machines Corporation
    Inventors: Frank Darl Bower, Roy J. Comford, Karelle Lynne Cornwell, William James Franklin, Saiyin Leung, John Richard Lyle, James Zu-Chia Teng, Jay A Yothers