Discussion:
Best method available in DB2 LUW for replication couple of tables to other DB2 LUW database
(too old to reply)
Tonyaaron100
2016-10-14 20:06:50 UTC
Permalink
Hello Gurus

I have requirement to replicate couple of tables from database A, and database B to database C and want to generate query on top of it for reporting purpose, what is the Best method available in DB2 LUW for replication couple of tables to other DB2 LUW database. I would appreciate all your help and insight. Thx

regards
Antony
v***@gmail.com
2016-10-15 19:06:36 UTC
Permalink
Post by Tonyaaron100
Hello Gurus
I have requirement to replicate couple of tables from database A, and database B to database C and want to generate query on top of it for reporting purpose, what is the Best method available in DB2 LUW for replication couple of tables to other DB2 LUW database. I would appreciate all your help and insight. Thx
regards
Antony
Infosphere Data Replication is the good solution i feel as per my experience.. DB2 10.5 AESE would provide limited use of IBM InfoSphere Data Replication's (IIDR's) Change Data Capture (CDC) technology at no additional cost.
Ramakrisna_N
2016-11-26 15:43:21 UTC
Permalink
Post by Tonyaaron100
Hello Gurus
I have requirement to replicate couple of tables from database A, and database B to database C and want to generate query on top of it for reporting purpose, what is the Best method available in DB2 LUW for replication couple of tables to other DB2 LUW database. I would appreciate all your help and insight. Thx
regards
Antony
hi Antony,

Instead of replication you can explore on Federated objects creating the nicknames of the source tables in the trarget database, no extra cost involved in it for DB2 database to DB2.

Regards
Ramakrishna
ox1d0
2016-11-29 20:50:51 UTC
Permalink
Post by Ramakrisna_N
Post by Tonyaaron100
Hello Gurus
I have requirement to replicate couple of tables from database A, and database B to database C and want to generate query on top of it for reporting purpose, what is the Best method available in DB2 LUW for replication couple of tables to other DB2 LUW database. I would appreciate all your help and insight. Thx
regards
Antony
hi Antony,
Instead of replication you can explore on Federated objects creating the nicknames of the source tables in the trarget database, no extra cost involved in it for DB2 database to DB2.
Regards
Ramakrishna
What about dprop , or qrep ? you can define signals in order to trigger the replication
Loading...