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
Best Regards, Guy Przytula
Database Software Consultant
Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
Information Server Datastage Certified http://www.infocura.be