Please use this identifier to cite or link to this item: http://hdl.handle.net/1959.3/20044

Download PDF (Published version) (Adobe Acrobat PDF, -1 bytes)

Title

Capturing global transactions from multiple recovery log files in a partitioned database system

Author(s)

Liu, Chengfei;  Lindsay, Bruce G.;  Bourbonnais, Serge;  Hamel, Elizabeth B.;  Truong, Tuong C.;  Stankiewitz, Jens

Abstract

DB2 DataPropagator is one of the IBM's solutions for asynchronous replication of relational data by two separate programs Capture and Apply. The Capture program captures changes made to source data from recovery log files into staging tables, while the Apply program applies the changes from the staging tables to target data. Currently the Capture program only supports capturing changes made by local transactions in a single database log file. With the increasing deployment of partitioned database systems in OLTP environments there is a need to replicate the operational data from the partitioned systems. This paper introduces a system called CaptureEEE which extends the Capture program to capture global transactions executed on partitioned databases supported by DB2 Enterprise-Extended Edition. The architecture and the components of CaptureEEE are presented. The algorithm for merging log entries from multiple recovery log files is discussed in detail.

Publication type

Conference paper

Source

Proceedings of the 29th International Conference on Very Large Data Bases (VLDB), Berlin, Germany, 09-12 September 2003, Vol. 29, pp. 987-996

Publication year

2003

Keyword(s)

Information systems

Publisher

Morgan Kaufmann

ISBN

0127224424

Publisher URL

http://www.vldb.org/conf/2003/homepage/uni_hro/proceedings.html

Copyright

Copyright © 2003 VLDB Endowment. Published version of the paper reproduced here in accordance with the copyright policy of the Very Large Database Endowment for noncommercial use only. No further redistribution is permitted without payment of a fee and/or special permission from the Endowment.

Full text

Peer reviewed