Hello,

One of our client working on creating a data warehouse solution. They need to export data out of their business systems. They want to export and import into their DWH solution not only complete set of rows from a db table but also changes only (since last export for given tables).
On z/OS we are suggesting for them that we can build some scripts that will use a product from Computer Associates called Log Analyzer that is able to read the internal DB log for changes that has been performed on database table (row updates, inserts and deletes). Via scripts, CA Log Analyser, shadow tables (storing delta rows) and data change capture turned on on selected DB2 tables we can provide delta rows.

Do you know about such a product for DB2 on iSeries. Please suggest

on LUW there is recovery expert - check if also for as400