Capturing database changes

MJBuillen · #1 (**permalink**) 04-06-04, 06:03

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.

sathyaram_s · #2 (**permalink**) 04-06-04, 06:23

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

For more details refer to Replication Guide and Reference

Cheers
Sathyaram

Quote:

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.

hurmavi · #3 (**permalink**) 04-06-04, 06:32

Quote:

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

Internet Services

Web Development

Digital Marketing

Consumer Tech