Restartable method to reorganize DB2 tablespace records by deter

Details Restartable method to reorganize DB2 tablespace records by deter Restartable method to reorganize DB2 tablespace records by deter

1993-12-07

1996-05-14

Black, Thomas G.

Boots, shoes, and leggings

3642516, 3642821, 3642834, 364DIG1, G06F 724, G06F 1730

Patent

active

055176410

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. Then any remaining non-clustering indices are reorganized using non-sorting techniques in a similar fashion.

REFERENCES:
patent: 4679139 (1987-07-01), durbin
patent: 4890226 (1989-12-01), Itoh
patent: 5034914 (1991-07-01), Osterlund
patent: 5204958 (1993-04-01), Cheng et al.
patent: 5222235 (1993-06-01), Hentz et al.
patent: 5257362 (1993-10-01), Menon
patent: 5274805 (1993-12-01), Ferguson et al.
Hauser et al. "DB2 2.3 REORG Tablespace Performance", DB Journal, Aug. 1992 pp. 24-29.

Affiliated with

Also associated with

Rating

Restartable method to reorganize DB2 tablespace records by deter does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Restartable method to reorganize DB2 tablespace records by deter, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Restartable method to reorganize DB2 tablespace records by deter will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-1904332