公开(公告)号：US20080270492A1

公开(公告)日：2008-10-30

申请号：US12171510

申请日：2008-07-11

申请人： FRANK DARL BOWER ,  Roy J. Cornford ,  Karelle Lynne Cornwell ,  William James Franklin ,  Saiyin Leung ,  John Richard Lyle ,  James Zu-Chia Teng ,  Jay A. Yothers

发明人： FRANK DARL BOWER ,  Roy J. Cornford ,  Karelle Lynne Cornwell ,  William James Franklin ,  Saiyin Leung ,  John Richard Lyle ,  James Zu-Chia Teng ,  Jay A. Yothers

IPC分类号： G06F17/30

CPC分类号： G06F17/30595 ,  G06F17/30312 ,  Y10S707/99931 ,  Y10S707/99933 ,  Y10S707/99943 ,  Y10S707/99956

摘要： 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.

摘要翻译： 提供了一种用于在线重组并增加DB2对象的页面大小的方法。 通过数据库实用程序DB2 REORG实用程序同时重组基表和相关辅助表空间。 数据库实用程序确定哪些辅助表与基表相关，并在实用程序的相同调用中自动包括其各自的辅助表。 重组通过分配的阴影数据集执行; 分配的影子数据集的页面大小在重组期间动态更新。 使用新建的影子数据集切换原始数据集，并使用新的页面大小值更新DB2目录值和控制块。

公开(公告)号：US07447717B2

公开(公告)日：2008-11-04

申请号：US10711826

申请日：2004-10-07

申请人： Frank Darl Bower ,  Roy James Cornford ,  Karelle Lynne Cornwell ,  William James Franklin ,  Saiyin Leung ,  John Richard Lyle ,  James Zu-Chia Teng ,  Jay A. Yothers

发明人： Frank Darl Bower ,  Roy James Cornford ,  Karelle Lynne Cornwell ,  William James Franklin ,  Saiyin Leung ,  John Richard Lyle ,  James Zu-Chia Teng ,  Jay A. Yothers

IPC分类号： G06F12/00 ,  G06F17/30

CPC分类号： G06F17/30595 ,  G06F17/30312 ,  Y10S707/99931 ,  Y10S707/99933 ,  Y10S707/99943 ,  Y10S707/99956

摘要： 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.

摘要翻译： 提供了一种用于在线重组并增加DB 2对象的页面大小的方法。 通过数据库实用程序DB 2 REORG实用程序同时重组基表和相关辅助表空间。 数据库实用程序确定哪些辅助表与基表相关，并在实用程序的相同调用中自动包括其各自的辅助表。 重组通过分配的阴影数据集执行; 分配的影子数据集的页面大小在重组期间动态更新。 使用新建的影子数据集切换原始数据集，并使用新的页面大小值更新DB 2目录值和控制块。

公开(公告)号：US08306978B2

公开(公告)日：2012-11-06

申请号：US12171510

申请日：2008-07-11

申请人： Frank Darl Bower ,  Roy J. Comford ,  Karelle Lynne Cornwell ,  William James Franklin ,  Saiyin Leung ,  John Richard Lyle ,  James Zu-Chia Teng ,  Jay A Yothers

发明人： Frank Darl Bower ,  Roy J. Comford ,  Karelle Lynne Cornwell ,  William James Franklin ,  Saiyin Leung ,  John Richard Lyle ,  James Zu-Chia Teng ,  Jay A Yothers

IPC分类号： G06F7/00 ,  G06F17/30

CPC分类号： G06F17/30595 ,  G06F17/30312 ,  Y10S707/99931 ,  Y10S707/99933 ,  Y10S707/99943 ,  Y10S707/99956

摘要： 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.

摘要翻译： 提供了一种用于在线重组并增加DB2对象的页面大小的方法。 通过数据库实用程序DB2 REORG实用程序同时重组基表和相关辅助表空间。 数据库实用程序确定哪些辅助表与基表相关，并在实用程序的相同调用中自动包括其各自的辅助表。 重组通过分配的阴影数据集执行; 分配的影子数据集的页面大小在重组期间动态更新。 使用新建的影子数据集切换原始数据集，并使用新的页面大小值更新DB2目录值和控制块。