We have 3 mainframe machines A, B and C in our system. The DB2 database resides in the mainframe machine A and it is where the DB2 tables get updated through different transactions. We need to retrieve the data from this DB2 database,on machine A, from Machine B and C.
One of the approach would be to replicate the DB2 database in Machine B and C as same as in Machine A.
I wanted to know if there is any other approach by which we can retrieve the data.
You need to go for CDC( Change Data Capture ). Like capturing data from Daily Prod sub-system to warehousing sub-system.
Do you have any DB2 Tools like Log Analyzer, but using tools like that you get any DML activities against a table. It can generate DELETE , INSERT & UPDATE statements, which you can run on other sub-system with a little manipulations.