Results 1 to 2 of 2

Thread: DB2 on iSeries

  1. #1
    Join Date
    Jul 2010

    Unanswered: DB2 on iSeries


    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

  2. #2
    Join Date
    Apr 2006
    Provided Answers: 11
    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-V11 Fundamentals- DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts