Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2008

    Arrow Unanswered: Data changes in database over a period of time.

    Hi all,

    DB version: DB2 UDB 8.2
    OS : Windows 2003 SP1

    I would like to know is there any way to find out the delta of database updates, deletes & new data over a typical period of time.

    Yesterday, DB size was 100 GB.
    Today, DB size is 102 GB.

    I would like to know the changes that are happened to the database (may be like 2GB deletions and 4 DB updations/additions)

    Help/Hints are greatly appreciated.

    Thanks in advance.


  2. #2
    Join Date
    Jul 2002
    There is no way you can track the data changes unless you have triggers setup on each table.

    verymost you can run a dynamic sql snapshot to see all the sqls ran on the database

  3. #3
    Join Date
    Jul 2006
    Pune , India
    if replication is enabled than you can track no of insert\update etc.
    i think may be db2 audit might have some options
    Rahul Singh
    Certified DB2 9 DBA / Application Developer

Posting Permissions

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