Method and apparatus for resolving automatic transaction facility (ATF) failures
An automated method is provided for resolving an unintended transaction rollback 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, wherein the unintended transaction rollback is the result of a failure of the facility to convert the unintended transaction rollback to a commit operation, 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 transaction rollbacks. A determination is made when a detected transaction rollback for a database transaction is an unintended transaction rollback. The one or more transaction steps or operations of the database transaction that included the unintended transaction rollback are recovered in the audited database. The recovering resolves the unintended transaction rollback.
1. An automated method of resolving an unintended transaction rollback in a system that includes (i) an audited database, (ii) a non-audited application, and (iii) a facility for converting non-audited applications to use audited database transactions, the method comprising:
(a) operating the non-audited application with the facility creating database transactions against the audited database, the database transactions including one or more transaction steps or operations;
(b) monitoring the created database transactions to detect transaction rollbacks;
(c) determining when a detected transaction rollback for a database transaction is an unintended transaction rollback, wherein the unintended transaction rollback is the result of a failure of the facility to convert the unintended transaction rollback to a commit operation; and
(d) recovering in the audited database the one or more transaction steps or operations of the database transaction that included the unintended transaction rollback, wherein the recovering resolves the unintended transaction rollback,
wherein the recovering includes reapplying and committing the one or more transaction steps or operations of the database transaction that included the unintended transaction rollback.
2. The method of claim 1 wherein the monitoring occurs by using alerts.
3. The method of claim 2 wherein the alerts are operating system signals.
4. The method of claim 2 wherein the alerts are inter-process communications.
5. The method of claim 1 wherein the monitoring occurs by reading an audit trail of the audited database.
6. The method of claim 1 wherein the unintended transaction rollback is the result of a failure in a central processing unit (CPU) where the non-audited application is operating.
7. The method of claim 1 wherein the unintended transaction rollback is the result of a failure in a central processing unit (CPU) where the facility is operating.
8. The method of claim 1 wherein the unintended transaction rollback is the result of a failure in the facility.
9. The method of claim 1 wherein the facility is an intercept library.