System and method for concurrently reorganizing logically...

Details System and method for concurrently reorganizing logically... System and method for concurrently reorganizing logically...

2007-02-20

2007-02-20

Vo, Tim (Department: 2168)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C707S793000

Reexamination Certificate

active

10687597

ABSTRACT:
A base table and related auxiliary table spaces are reorganized concurrently via a database 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. The original data sets are switched with the newly built shadow data sets including the LOB shadows.

REFERENCES:
patent: 5842208 (1998-11-01), Blank et al.
patent: 6038569 (2000-03-01), Beavin et al.
patent: 6122640 (2000-09-01), Pereira
patent: 6163783 (2000-12-01), Hintz et al.
patent: 6237003 (2001-05-01), Lewish et al.
patent: 6272486 (2001-08-01), Garth et al.
patent: 6457014 (2002-09-01), Parker
patent: 6460048 (2002-10-01), Teng et al.
patent: 6606617 (2003-08-01), Bonner et al.
patent: 6738790 (2004-05-01), Klein et al.
patent: 2002/0065792 (2002-05-01), Bonner et al.
patent: 2002/0138497 (2002-09-01), Chen et al.
patent: 2003/0135478 (2003-07-01), Marshall et al.
“A Novel Facility for Exploring the Contents of a Datasource,”IBM Technical Disclosure Bulletin, v33, N7, Dec. 1990, pp. 177-80.
“Spanning Temporary Reorg Files,”IBM Technical Disclosure Bulletin, v36, N6A, Jun. 1993, p. 159.

Affiliated with

Also associated with

Rating

System and method for concurrently reorganizing logically... does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with System and method for concurrently reorganizing logically..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and System and method for concurrently reorganizing logically... will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3853065