Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Posts
    2

    Unanswered: Capturing database changes

    Hi,

    I'm running DB2 7.2 on an NT platform, and need to extract new rows of data, or rows of data that have changed throughout the day. This data will eventually be imported into another database off-site. Does anyone know of some softare that would help achieve this ?

    Any help really appreciated.

    M.

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: Capturing database changes

    DB2 Replication Capture program will be able to do this ...

    For more details refer to Replication Guide and Reference


    Cheers
    Sathyaram

    Originally posted by MJBuillen
    Hi,

    I'm running DB2 7.2 on an NT platform, and need to extract new rows of data, or rows of data that have changed throughout the day. This data will eventually be imported into another database off-site. Does anyone know of some softare that would help achieve this ?

    Any help really appreciated.

    M.
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Jan 2004
    Location
    Europe, Finland, Helsinki
    Posts
    64

    Re: Capturing database changes

    Originally posted by sathyaram_s
    DB2 Replication Capture program will be able to do this ...

    For more details refer to Replication Guide and Reference


    Cheers
    Sathyaram
    True!

    We have used in our house very successfully triggers, but then then beware - triggers can have some performance problems. In our case replicated material is some 1000 rows per day - small enough to do with a trigger.

    Cheers, Bill

Posting Permissions

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