Method and apparatus for resolving abnormal database transaction termination resulting from automatic transaction facility (atf) failures

Abstract

Methods and apparatus are provided for resolving an abnormal database transaction termination in a system that includes an audited database, a non-audited application, and a facility for converting non-audited applications to use audited database transactions. The non-audited application is operated with the facility creating database transactions against the audited database. The database transactions include one or more transaction steps or operations. The created database transactions are monitored to detect database transaction terminations. A determination is made whether a detected database transaction termination is an abnormal database transaction termination, and, if so, whether the abnormal database transaction termination requires intervention. The one or more transaction steps or operations of the database transaction are recovered in the audited database when the abnormal database transaction termination requires intervention. The recovering includes reapplying and committing the one or more transaction steps or operations of the database transaction.