Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2004-10-07
2008-11-04
Vo, Tim (Department: 2168)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000, C707S793000, C707S793000, C707S793000, C707S793000
Reexamination Certificate
active
07447717
ABSTRACT:
Provided is a method for online reorganization and increasing the page size of a DB2object. A base table and related auxiliary table spaces are reorganized concurrently via a database utility, DB2REORG 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 DB2catalog values and control blocks are updated with new page size values.
REFERENCES:
patent: 5222235 (1993-06-01), Hintz et al.
patent: 5396623 (1995-03-01), McCall et al.
patent: 5625815 (1997-04-01), Maier et al.
patent: 5887274 (1999-03-01), Barry et al.
patent: 6122640 (2000-09-01), Pereira
patent: 6144970 (2000-11-01), Bonner et al.
patent: 6343296 (2002-01-01), Lakhamraju et al.
patent: 6460048 (2002-10-01), Teng et al.
patent: 6519613 (2003-02-01), Friske et al.
patent: 6535893 (2003-03-01), Friske et al.
patent: 6535895 (2003-03-01), Bonner et al.
patent: 6591269 (2003-07-01), Ponnekanti
patent: 6606631 (2003-08-01), Martin, Jr. et al.
patent: 6694340 (2004-02-01), Lyle et al.
patent: 6738388 (2004-05-01), Stevenson et al.
patent: 6745211 (2004-06-01), Kabasakalian et al.
patent: 6965899 (2005-11-01), Subramaniam et al.
patent: 2001/0047360 (2001-11-01), Huras et al.
patent: 2002/0143743 (2002-10-01), Iyer et al.
patent: 2003/0046294 (2003-03-01), Heronimus
patent: 2003/0056082 (2003-03-01), Maxfield
patent: 2003/0115220 (2003-06-01), Chan et al.
patent: 2003/0130985 (2003-07-01), Driesen et al.
patent: 2003/0135478 (2003-07-01), Marshall et al.
patent: 2004/0015469 (2004-01-01), Beier et al.
patent: 2005/0251523 (2005-11-01), Rajamani et al.
patent: WO 02/098048 (2002-12-01), None
patent: WO 03/009180 (2003-01-01), None
Database Reorganization—Principles and Practices, Sockut, Gary H. and Goldberg, Robert P., Computing Surveys, vol. 11, No. 4, Dec. 1979, pp. 371-395.
‘DB2 Universal Database Performance Turning’, by Schiefer et al, Bulletin of the Technical Committee on Data Engineering, Jun. 1999, vol. 22, No. 2, IEEE Computer Society, pp. 12-19.
“Technique to Allow DB2 Utilities and Commands to Run While SQL Applications have a Table Space Locked,” IBM Technical Disclosure Bulletin, V36, N9A, Sep. 1993, pp. 499-501.
“Online Reorg,” <http://www.alancsmith.co.uk/db2/olro/onlinero.html>.
Bower Frank Darl
Cornford Roy James
Cornwell Karelle Lynne
Franklin William James
Leung Saiyin
International Business Machines - Corporation
IP Authority, LLC
Morrison Jay A
Plow Gregory
Soundararajan Ramraj
LandOfFree
Method of changing the page size of a DB2 table space while... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Method of changing the page size of a DB2 table space while..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method of changing the page size of a DB2 table space while... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-4030777