Data processing: database and file management or data structures – Database design – Data structure types
Patent
1996-01-19
1998-05-26
Black, Thomas G.
Data processing: database and file management or data structures
Database design
Data structure types
707101, G06F 1730
Patent
active
057583579
ABSTRACT:
An improved method to dramatically reduce the time required to reorganize DB2 tablespaces and index files by not utilizing conventional sort techniques. Viewing access is allowed during the reorganization process by setting the files to read only status. The process is basically non-destructive, allowing a prompt return to the original state, and is checkpointed, allowing restarting at selected intervals. Briefly, the original table and indices are considered as A files and read into memory. New row IDs or RIDs are developed using a non-sorting technique so that the proper order of the data is developed. After the new RIDs have been developed, both the clustering index and the row data are read out of memory and written to a new table and clustering index files in the proper order as B files. All of the table files are then stopped to allow exclusive access. Next, a series of AMS statements are built to do the renaming operations. Specifically, a series of statements are built to rename all of the A files to X files, to rename all B files to A files and then to delete all of the X files. Then any remaining non-clustering indices are reorganized using non-sorting techniques and renamed in a similar fashion.
REFERENCES:
patent: 4679139 (1987-07-01), Durbin
patent: 4890226 (1989-12-01), Itoh
patent: 5034914 (1991-07-01), Osterlund
patent: 5121493 (1992-06-01), Ferguson
patent: 5204958 (1993-04-01), Cheng
patent: 5222235 (1993-06-01), Hintz
patent: 5257362 (1993-10-01), Menon
patent: 5274805 (1993-12-01), Ferguson
Walker, H., Introduction to Computing and Computer Science with Pascal, pp. 246-247, Jan. 1986.
Hauser et al., "DB2 2.3 Reorg Tablespace Performance," DB Journal, Aug. 1992, pp. 24-29.
IBM DB2 Utilities Guide, Reorg Chap, pp. 103-114.
IBM DB2 Command and Utility Reference, pp. 266-272, Reorg Utility.
Platinum, Put User Guide, pp. 4-1 to 4-10, 1992.
ALeisa Eisa A.
Barry Richard E.
Black Thomas G.
Choules Jack M.
DBC Software, Inc.
LandOfFree
Fast DB2 tablespace reorganization method that is restartable af does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Fast DB2 tablespace reorganization method that is restartable af, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Fast DB2 tablespace reorganization method that is restartable af will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-1978852