Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

DB2 database data synchronous update method and device

A synchronous update and data synchronization technology, applied in the computer field, can solve problems such as taking a long time, affecting the application program, and affecting the data consistency of the target library

Active Publication Date: 2019-01-25
WUHAN DAMENG DATABASE
View PDF6 Cites 9 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

If you do not keep the S lock on the table, then when a table is initialized, the query operation will read the data submitted by other transactions during the extraction of the query result set. When synchronization is enabled after the initialization, the transactions generated during the extraction of the result set will be read. is synchronized again, which affects the consistency of the target database data
If you keep the S lock on the table, when the amount of data in the source data table is very large, the query result set will take a long time, and keeping the S lock on the synchronization table for a long time will have a great impact on the application program on the database

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • DB2 database data synchronous update method and device
  • DB2 database data synchronous update method and device
  • DB2 database data synchronous update method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0024] In order to make the purpose, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions in the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments It is a part of embodiments of the present invention, but not all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without creative efforts fall within the protection scope of the present invention. In addition, the technical features in each embodiment or a single embodiment provided by the present invention can be arbitrarily combined with each other to form a feasible technical solution, but it must be based on the realization of those skilled in the art. When there is a contradiction or cannot be realized, it should be considered that the c...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The embodiment of the invention provides a DB2 database data synchronous update method and device. The method comprises the following steps: a data detailed address storage column is created accordingto a table to be synchronously updated; an S lock on the table to be synchronously updated is obtained; the current log sequence number LSN of the DB2 database at the source end is used as a startingLSN of the table to be synchronously updated; and the S lock is released; Obtaining a result set of a table to be updated synchronously, sending the result set to a database at a target end for storage, and obtaining a current LSN of a DB2 database at a source end as an end LSN of the table to be updated synchronously; Receiving the initialization data sent by the synchronous update service of the source end, inserting the ROWID into the data detailed address storage column in the database of the target end, and initializing the data of the table to be synchronized update; Start the Data Real-time Synchronous Update Service and send the changes of the source DB2 database to the target database for data synchronous updates. The embodiments of the invention can avoid the adverse influence of the S lock on the table to be synchronously updated for a long time on the premise of ensuring the consistency of the database data at the target end.

Description

technical field [0001] The embodiment of the present invention relates to the field of computer technology, in particular to a method and device for synchronously updating DB2 database data. Background technique [0002] In the software-based database data replication technology, the real-time data synchronization technology based on database log analysis supports heterogeneous system replication, and the heterogeneous standby machine can read and write, and the impact on the source database is relatively small, so real-time replication in the database fields are widely used. At present, the main technical principle of using the data synchronization service to initialize the database data is to first lock the S lock on the synchronization table in the source database to prevent other transactions from modifying the synchronization table, and query the LSN value of the current database as the table increment Synchronize the starting LSN, and then use the SELECT statement to ...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Applications(China)
IPC IPC(8): G06F16/27G06F16/23G06F16/242
Inventor 付铨孙峰赵家威杨春
Owner WUHAN DAMENG DATABASE
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products