Invention Grant
- Patent Title: Batch job performance improvement in active-active architecture
-
Application No.: US17110523Application Date: 2020-12-03
-
Publication No.: US11461315B2Publication Date: 2022-10-04
- Inventor: Shuo Li , Xiaobo Wang , Jia Tian Zhong , Sheng Yan Sun
- Applicant: International Business Machines Corporation
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agent Stephanie L. Carusillo
- Main IPC: G06F16/242
- IPC: G06F16/242 ; G06F16/28

Abstract:
In an approach for improving performance of a batch job running on database servers in an active-active architecture. A processor, responsive to a batch job being ready to be executed on a source database server, sends a first communication to a target database server with a synchronization start point. While executing the batch job, a processor utilizes a pre-lock function, pre-load function, and lock avoidance function to prevent lock conflicts. A processor, responsive to either the source database server or the target database server encountering a commit statement, suspends the respective database server and sends a second communication to ask if the other respective database server is ready to complete the commit statement. A processor, responsive to the other respective database server confirming its ready to complete the commit statement, completes the commit statement on both the source database server and the target database server.
Public/Granted literature
- US20220179852A1 BATCH JOB PERFORMANCE IMPROVEMENT IN ACTIVE-ACTIVE ARCHITECTURE Public/Granted day:2022-06-09
Information query