The Research And Implementation Of DB2 Data Update Detecting In The Common Log Analysis.

Nowadays, how to find the useful information from the large numbers of data which is distributed in everywhere is a question to be solved. One efficient solution is the universal data integration technology which is developed from the idea of data warehouse online maintenance technology.With the requirement of the applications improved, it is not satisfied with the former passive data integration technology any more. The data integration technology is becoming more and more active and intellectualized presently. The intellectualized data integration system is composed of intellectualized monitor agent and the information integration mostly. And the intellectualized monitor agent is composed of the update event monitor, ECA regulation system and the view increment deliver system. This article's emphasis is the research and implement of the DB2 log analysis in the update event monitor module. The log analysis is the starter of the whole intellectualized monitor agent and its responsibility is to capture the source mutative information. The research carries out by reading and analyzing the database log outside the database mostly.This article focuses on the following items:Firstly, it will research and analyze the principle of the DB2 log and its file structure. And it will discuss the details of the log record which is concerned with the update detecting process.Secondly, it will analyze the log reading and the log analysis of the DB2 database in theory.Finally, it will analyze the update detecting process of the DB2 database base on the conclusion we get from the article and the finished universal detecting frame work. It will propose an optimum scheme in order to integrate the DB2 log analysis module to the update detecting system.