MVSFORUMS.com

yadav2005 · Intermediate Joined: 10 Jan 2005 Posts: 348 Topics: 144

Members,

I am interested in setting up Data Propagation in my shop and I do not have any basic idea on how to proceed.I have Production Region and Test Region and I want to setup on Mainframes.Can anybody guide me further as I am really lacking guidance.

Anuj Dhawan · Posted: Wed Sep 08, 2010 4:08 am Post subject:

Are you asking about the distribution of data from one or more source data warehouses to one or more local access databases, according to propagation rules.

If yes, Data warehouses (DWH) need to manage big bulks of data every day. A data warehouse may start with a few data, and starts to grow day by day by constant sharing and receiving from various data sources - so have you contacted your DWH Team?
_________________
Regards,
Anuj

yadav2005 · Intermediate Joined: 10 Jan 2005 Posts: 348 Topics: 144

Anuj,

I am looking for a setup to learn data propagation in the below way:

a) table existing with data on Production
b) table existing with the same data on test
c) capturing the changes which are done in one hour on production by automating a batch job
d) apply the changes to test by automating a batch job
e) compare the count of records on prd
f) compate the count of records on test

Please let me know if you need more details from me .

kolusu · Posted: Wed Sep 08, 2010 11:24 am Post subject:

yadav2005,

Start reading "Replication and Event Publishing Guide and Reference " here

http://www.ibm.com/support/docview.wss?rs=3557&uid=swg27016356

Kolusu

Anuj Dhawan · Posted: Thu Sep 09, 2010 4:01 am Post subject:

You mihgt like this article too: http://www.information-management.com/issues/19990301/106-1.html . Have a look.
_________________
Regards,
Anuj

yadav2005 · Intermediate Joined: 10 Jan 2005 Posts: 348 Topics: 144

Thanks Kolusu and Anuj. Links are great.

Anuj Dhawan · Posted: Fri Sep 10, 2010 8:15 am Post subject:

Good Luck... Smile

.
_________________
Regards,
Anuj