The flat file not having a logging mechanism will not have a basis on what
changed. I am thinking, what if you define a nickname in DB2 pointing to
that flat file and try to replicate using Data Propagator that View, one
limitation though is changes should occur in the view. If changes occur
outside DB2 or in the flat file iteself, changes will still not be captured.
Another alternative is just to "refresh" the table every so often, and maybe
use a timestamp field as your where clause so that it only extracts data
with certain timestamps (but you will need to write code that changes that
timestamp like where system time is between time1 and time2). This will sort
of be an incremental "extract" extracting data based on timestamp that was
not yet extracted. This might still be resource intensive though because it
will read the whole table everytime it "extracts" data.
RdR
"Knut Stolze" <st****@de.ibm.com> wrote in message
news:d0**********@fsuj29.rz.uni-jena.de...
Stanley Sinclair wrote:
Can I "replicate" from a flat file which changes, but is not a part of
a formal database?
At first glance, I'd say you can do that using a table function that
presents the file as table to DB2. However, you have to be able to
provide the necessary change data for the CD/CCD tables so that replication knows
which changes did occur and need to be propagated to the target systems.
--
Knut Stolze
Information Integration
IBM Germany / University of Jena