公开(公告)号：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.

公开(公告)号：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.