Abstract: In computer methods and systems for operating a database management system using a catalog table collection module each table in the database management system is cataloged. Multiple tables are automatically dispatched into multiple consistency groups by collecting real-time statistics using a real time statistics module. Workload profile data of the database management system is generated using a workload profile collection module, and an optimized multiple consistency group definition for the database management system is generated using a transaction splitting analysis module.

Abstract: Embodiments of the invention are directed to data replication in an active-active databases having a source site and a target site. Aspects include creating a subscription activation message in a capture address space, the subscription activation message having a timestamp after a latest committed timestamp of the active-active databases and transmitting the subscription activation message to a subscription activation module of the target site of the active-active databases. Based on a determination that one or more tables associated with the subscription activation message are inactive, aspects also include repairing the one or more tables. Based on a determination that all tables associated with the subscription activation message are active, aspects include initiate replication of the capture address space from the source site to the target site with a timestamp of the latest committed timestamp.

Abstract: Embodiments of the invention are directed to data replication in an active-active databases having a source site and a target site. Aspects include creating a subscription activation message in a capture address space, the subscription activation message having a timestamp after a latest committed timestamp of the active-active databases and transmitting the subscription activation message to a subscription activation module of the target site of the active-active databases. Based on a determination that one or more tables associated with the subscription activation message are inactive, aspects also include repairing the one or more tables. Based on a determination that all tables associated with the subscription activation message are active, aspects include initiate replication of the capture address space from the source site to the target site with a timestamp of the latest committed timestamp.

Abstract: In an embodiment, a computer-implemented method comprises deploying a dual-active database on a first active database site and a second active database site. The first active database site comprises a first group of disks including a first sub-group of disks and a second sub-group of disks respectively corresponding to a third sub-group of disks and a fourth sub-group of disks included in a second group of disks in the second active database site. The method further comprises storing a first set of database logs on the first sub-group of disks while a second set of database logs is being written on the second sub-group of disks. Contents of the second set of database logs are consistent with contents of the first set of database logs and function as a duplication of the first set of database logs.

Abstract: In an embodiment, a computer-implemented method comprises deploying a dual-active database on a first active database site and a second active database site. The first active database site comprises a first group of disks including a first sub-group of disks and a second sub-group of disks respectively corresponding to a third sub-group of disks and a fourth sub-group of disks included in a second group of disks in the second active database site. The method further comprises storing a first set of database logs on the first sub-group of disks while a second set of database logs is being written on the second sub-group of disks. Contents of the second set of database logs are consistent with contents of the first set of database logs and function as a duplication of the first set of database logs.

Abstract: Aspects of the invention include a continuous availability for workload and site switches with no data loss at unlimited distances in an active-active sites configuration. A non-limiting example computer-implemented method includes synchronously replicating commit records of changed workload data, by a processor, from an active site to a bunker site upon a workload data commit. The method asynchronously replicates committed transactions on changed workload data, by the processor, from the bunker site to a recovery site.

Abstract: A computing system includes a first storage unit at a first computing site. The first storage unit stores units of work data and data synchronously replicated from a first server cluster of a second computing site. The system further includes a second server cluster at the first computing site, the second server cluster is a proxy node of the first server cluster. The system further includes a second storage unit at the first computing site, the second storage unit stores the units of work data and data from the first storage unit asynchronously into the second storage unit. The system further includes a third server cluster at the first computing site, the third server cluster processes the units of work data asynchronously replicated into the second storage unit.

Abstract: According to one or more embodiments of the technical solutions described herein, a computing system includes a first storage unit at a first computing site. The first storage unit stores units of work data and data synchronously replicated from a first server cluster of a second computing site. The computing system further includes a second server cluster at the first computing site, the second server cluster is a proxy node of the first server cluster. The computing system further includes a second storage unit at the first computing site, the second storage unit stores the units of work data and data from the first storage unit asynchronously into the second storage unit. The computing system further includes a third server cluster at the first computing site, the third server cluster processes the units of work data asynchronously replicated into the second storage unit.