International Business Machines Corporation

Gregory Walter Vance

Serge Bourbonnais

Paul Michael Cadarette

David B Petersen

Michael G Fitzpatrick

Pamela McLean

Karen Alicia Ranson

Donald Prentiss Terry

John Glenn Thompson

Vern Lee Watts

John Simon Tilling

Judy Y Tse

Francis Joseph Ricchio

David Wayne Moore

Martin W Cocks

Terry Lee Krein

David A Clitherow

Lawrence Edward Sullivan

A system for maintaining a two-site configuration for continuous availability over long distances may include a first computing site configured to execute a first instance associated with a priority workload, the first instance being designated as an active instance; a second computing site configured to execute a second instance of the priority workload, the second instance being designated as a standby instance; a software replication module configured to replicate a unit of work data associated with the priority workload from a first data object associated with the active instance to a second data object associated with the standby instance, and a hardware replication module configured to replicate an image from a first storage volume to a copy on a second storage volume, wherein the first storage volume is associated with the first computing site, and the second storage volume is associated with a third computing site.

Maintaining two-site configuration for workload availability between sites at unlimited distances for products and services

A method includes reading, by a capture engine, log data. The log data can be synchronously hardware-replicated. The log data reflects that an update was started for a database of a first site. The capture engine corresponds to a capture engine of a second site. The method also includes identifying, by the capture engine, the update. The method also includes determining whether the update was committed to the database of the first site. The method also includes replicating, by an apply engine, the update to a database of the second site based on the determining. The update is replicated to the database of the second site based on a determination that the update was committed to the database of the first site. The committed update corresponds to a consistent replication of updates across two or more databases that reside in multiple database management systems.

Ensuring consistent replication of updates in databases

A system for providing reliable availability of a general workload and continuous availability of a priority workload over long distances may include a first computing site configured to execute a first instance associated with the priority workload, wherein the first instance is designated as an active instance, a second computing site configured to execute a second instance of the priority workload, wherein the second instance is designated as a standby instance, a third computing site configured to restart a third instance associated with the general workload, and a workload availability module configured to synchronize a portion of data associated with the third instance with a corresponding portion of data associated with the second instance.

Managing continuous priority workload availability and general workload availability between sites at unlimited distances for products and services

A method for managing a plurality of workloads executing on both a primary system and on a secondary system, and synchronizing both a plurality of software data and a plurality of hardware data stored on the primary system with the secondary system is provided. The method may include receiving a region switch request and stopping the execution of the plurality of workloads on the primary system; suspending the replication of the plurality of software and hardware data stored on the primary system with the plurality of software and hardware data stored on the secondary system; and switching the replication of the plurality of software data and the plurality of hardware data that occurs from the primary system to the secondary system to occur from the secondary system to the primary system. The method may further include activating the execution of and synchronizing the plurality of workloads on the secondary system.

Management and synchronization of batch workloads with active/active sites OLTP workloads

The capturing of change data of deferred updates begins with the receipt of an update request call for one or more changes to a database. A processing of the update request call is deferred until a commit point is issued, where call information associated with the update request call is determined, and the call information is stored and associated with the update request call. During a processing of the commit point, data information for the one or more changes to the database is determined. The data information for the one or more changes is combined with the stored call information associated with the update request call.

Capturing change data of deferred updates

A data processing system and method of operation are disclosed. The data processing system includes a first site for processing data; a second site for processing data; and a transaction replay program configured to send a copy of data from the first site to the second site. A processor defines a maximum replication latency threshold and a reset threshold for the system, estimates a replication latency of a workload the system, switches the system to a first replication latency state when the estimated replication latency rises above the maximum replication latency and switches the system out of the first replication latency state to a second replication latency state when the estimated replication latency falls below the reset threshold.

Using average replication latency to influence routing query transactions

A computer system for managing a plurality of workloads executing on both a primary system and on a secondary system, and synchronizing both a plurality of software data and hardware data stored on the primary system with the secondary system is provided. The computer system may include receiving a region switch request and stopping the execution of the plurality of workloads on the primary system; suspending the replication of the plurality of software and hardware data stored on the primary system with the plurality of software and hardware data stored on the secondary system; and switching the replication of the plurality of software data and the plurality of hardware data that occurs from the primary system to the secondary system to occur from the secondary system to the primary system. The computer system may include activating the execution of and synchronizing the plurality of workloads on the secondary system.

Embodiments of the disclosure are directed to methods, systems and computer program products for performing a planned workload switch. A method includes receiving a request to switch a site of an active workload and stopping one or more long running processes from submitting a new request to the active workload. The method also includes preventing a new network connection from accessing the active workload and processing one or more transactions in a queue of the active workload for a time period. Based on a determination that the queue of the active workload is not empty after the time period, the method includes aborting all remaining transactions in the queue of the active workload. The method further includes replicating all remaining committed units of work to a standby workload associated with the active workload.

Achieving continuous availability for planned workload and site switches with no data loss

An apparatus, system, and method are disclosed for providing parallel access to a data set configured for automatic recovery. The apparatus includes an access module, a conversion module, a recovery module, and a restore module. The access module establishes parallel access to a data set configured for 'pair and a spare' automatic recovery. The conversion module converts access to the data set from parallel access to single point access in response to an application instance detecting an error in the data set. The recovery module recovers the data set using an automatic recovery process initiated by the application instance that detects the error. The restore module restores access to the data set from single point access to parallel access in response to successful recovery of the data set. Providing parallel access to a data set configured for automatic recovery ensures that data transactions are performed swiftly, reliably, and efficiently.

Apparatus, system, and method for providing parallel access to a data set configured for automatic recovery

A method and apparatus for merging log data for recovering one or more database data sets to any point-in-time in a single pass of log data sets. Using disaster recovery technology, the invention may be implemented to provide a method to reduce the time that a broken database is unavailable by processing recovery input data in parallel and recovering multiple database data sets, including areas, simultaneously. The invention reduces operational complexity and resource constraints experienced by IMS customers trying to recover database data sets especially in a data sharing environment. The invention simplifies the recovery process by eliminating both the need for change accumulation and the need to run separate recovery jobs for each database data set requiring recovery, thereby reducing the impact of recovery on system resources.

Growing community of inventors

Morgan Hill, CA, United States of America

Gregory Walter Vance