DB2 database data synchronous update method and device

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 ...

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

Images