DB2 database data synchronous updating method and equipment

Abstract

Embodiments of the present invention provide a DB2 database data synchronization update method and device. The method includes: creating a data detailed address storage column according to the table to be updated to be synchronized, an S lock on the table to be updated to be synchronized, acquiring the current log sequence number LSN of the source DB2 database as the starting LSN of the table to be updated to be synchronized, and releasing the S lock; Obtain the result set of the table to be synchronized and updated, send the result set to the target database for storage, and obtain the current LSN of the source DB2 database as the end LSN of the table to be synchronized and updated; receive the initialization data sent by the source synchronization update service, on the target The database inserts ROWID into the data detailed address storage column, initializes the data of the table to be updated synchronously; starts the real-time data synchronization update service, and sends the changes of the source DB2 database to the target database for data synchronization update. Various embodiments of the present invention can avoid the adverse effects caused by the S lock on the table to be synchronously updated for a long time under the premise of ensuring the data consistency of the target database.

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