International Business Machines Corporation

Hiromi Masuda

James Zu-Chia Teng

Shyh-Yee Wang

Jack R Shedden

A requester includes a business process history DB having recorded therein GBPIDs, input messages, and provider names, and each of providers includes a log DB having recorded therein log data containing DBPIDs and images before updates of the DB. Moreover, in the requester, an UNDO information creator and a REDO information creator refer to the business process history DB to respectively create UNDO information and REDO information for the provider in charge of the business process of a GBPID after the modification REDO. Furthermore, in the provider, an UNDO processor and a REDO processor refer to the log DB to respectively perform UNDO and REDO processes.

Controlling execution of transactions

An integrated DBMS solution to recover primary site database based upon the maintenance of a shadow copy of the primary site's database data and logs at a remote site. Both the primary site DBMS and the remote site DBMS may support write-ahead logging protocol in which log records are written to a log data set before database updates are entered into the remote site storage. The remote site serves at least two functions: as a &ldquo;tracker&rdquo; DBMS and as a &ldquo;take-over&rdquo; DBMS. The tracker function maintains a shadow copy of the primary site's database data sets at the remote site. The multi-phased take-over function uses the shadow copies to update the remote site database data sets and substitutes them for primary site database data sets made unavailable by an unplanned disaster at the primary site.

Growing community of inventors

Osaka, Japan

Hiromi Masuda