Invention Grant
US08306978B2 Method of changing the page size of a DB2 table space while keeping the object available
失效
在保持对象可用的同时更改DB2表空间的页面大小的方法
- Patent Title: Method of changing the page size of a DB2 table space while keeping the object available
- Patent Title (中): 在保持对象可用的同时更改DB2表空间的页面大小的方法
-
Application No.: US12171510Application Date: 2008-07-11
-
Publication No.: US08306978B2Publication Date: 2012-11-06
- Inventor: Frank Darl Bower , Roy J. Comford , Karelle Lynne Cornwell , William James Franklin , Saiyin Leung , John Richard Lyle , James Zu-Chia Teng , Jay A Yothers
- Applicant: Frank Darl Bower , Roy J. Comford , Karelle Lynne Cornwell , William James Franklin , Saiyin Leung , John Richard Lyle , James Zu-Chia Teng , Jay A Yothers
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agency: IP Authority, LLC
- Agent Ramraj Soundararajan
- Main IPC: G06F7/00
- IPC: G06F7/00 ; G06F17/30
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.
Public/Granted literature
- US20080270492A1 METHOD OF CHANGING THE PAGE SIZE OF A DB2 TABLE SPACE WHILE KEEPING THE OBJECT AVAILABLE Public/Granted day:2008-10-30
Information query
