公开(公告)号：DE68926693D1

公开(公告)日：1996-07-25

申请号：DE68926693

申请日：1989-02-24

Applicant: IBM

Inventor： ELLIOTT LINDA CAROLYN ,  HORN GARY RANDALL ,  JODAN LLOYD EUGENE ,  LEVINE FRANK ELIOT ,  SHIH GENG-FONG ,  MYRE WILLIAM WALTER

IPC: G06F11/14 ,  G06F12/00 ,  G06F7/22

Abstract: System and method for reducing data loss in a database system during I/O errors and power failure during non-atomic writes to media in a transaction management system using write-ahead logging protocol. A recovery log is written during forward processing. On system restart processing, the log is traversed and a REDO executed. Recovery is effected from detected incomplete log writes or log write failures and uncommitted transactions are undone. A technique is provided in which files having I/O errors are identified, whereby subsequent restart operations are prevented from accessing these files. In one embodiment index files with such error are renamed, serving to indicate that corresponding original files contain errors, and the error index files are automatically rebuilt whereby I/O error on the files causes no data loss. The index file rebuild does not invalidate access plans related to the failed index.

公开(公告)号：DE68922431D1

公开(公告)日：1995-06-08

申请号：DE68922431

申请日：1989-02-24

Applicant: IBM

Inventor： MYRE WILLIAM WALTER ,  SHIH CHENG-FONG

IPC: G06F7/22 ,  G06F11/14 ,  G06F12/00

Abstract: Functions MINBUFLSN and LOWTRANLSN, implemented in a computerized routine, are defined and comprise first and second components of a checkpoint. MINBUFLSN is functionally related to a first update to a first of "dirty" data pages in the RAM buffer. LOWTRANLSN is functionally related to the earliest update of a sequence in a transaction table wherein each update corresponds to an uncommitted transaction. The two components are derived during write-ahead logging and stored in the log header periodically as a function of logging activity. Upon recovery, the checkpoint is retrieved and a functional comparison between the components thereof employed in the recovery algorithm. The conventional analysis pass of the recovery log is avoided and a reduced overhead during logging is provided as well as an efficient recovery.

公开(公告)号：DE68926693T2

公开(公告)日：1997-01-23

申请号：DE68926693

申请日：1989-02-24

Applicant: IBM

Inventor： ELLIOTT LINDA CAROLYN ,  HORN GARY RANDALL ,  JODAN LLOYD EUGENE ,  LEVINE FRANK ELIOT ,  SHIH GENG-FONG ,  MYRE WILLIAM WALTER

IPC: G06F11/14 ,  G06F12/00 ,  G06F7/22

Abstract: System and method for reducing data loss in a database system during I/O errors and power failure during non-atomic writes to media in a transaction management system using write-ahead logging protocol. A recovery log is written during forward processing. On system restart processing, the log is traversed and a REDO executed. Recovery is effected from detected incomplete log writes or log write failures and uncommitted transactions are undone. A technique is provided in which files having I/O errors are identified, whereby subsequent restart operations are prevented from accessing these files. In one embodiment index files with such error are renamed, serving to indicate that corresponding original files contain errors, and the error index files are automatically rebuilt whereby I/O error on the files causes no data loss. The index file rebuild does not invalidate access plans related to the failed index.

公开(公告)号：DE68922431T2

公开(公告)日：1996-01-25

申请号：DE68922431

申请日：1989-02-24

Applicant: IBM

Inventor： MYRE WILLIAM WALTER ,  SHIH CHENG-FONG

IPC: G06F7/22 ,  G06F11/14 ,  G06F12/00

Abstract: Functions MINBUFLSN and LOWTRANLSN, implemented in a computerized routine, are defined and comprise first and second components of a checkpoint. MINBUFLSN is functionally related to a first update to a first of "dirty" data pages in the RAM buffer. LOWTRANLSN is functionally related to the earliest update of a sequence in a transaction table wherein each update corresponds to an uncommitted transaction. The two components are derived during write-ahead logging and stored in the log header periodically as a function of logging activity. Upon recovery, the checkpoint is retrieved and a functional comparison between the components thereof employed in the recovery algorithm. The conventional analysis pass of the recovery log is avoided and a reduced overhead during logging is provided as well as an efficient recovery.