Re: 1.5 TB Warehouse: Informix or DB2/MVS?

Peter Nolan <PNOLAN@ozemail.com.au> writes: >Hi Bob, > with these volumes you would be looking at a large server housing >the vast volume of the transaction level data and also preparing the >aggregated data in multiple fact tables. From there you would distribute >the data to regional servers. IBM has very good technology with Data >Propagator to do the propagation to regional servers for you. >We are testing dpropr now and will be moving to distributed servers >in s subsequent releases.... >Please feel free to mail me directly. >Peter Nolan >Data Warehouse Specialist Peter, do you (or anybody else) can tell how DProps performance would be if you had to move 50 GB per day (or lets say a 5h batch window) into DB2/MVS or, even worse down into Informix? Using SQL processing, DRDA and Staging tables on the way would keep it from doing that job. Please correct me if you're expierence is different. Are you working with the DPropR V2? How is the impact on the production system? I#ve heard a lot bad expieriences with V1 in that area. Regards, Martin ----------------------------------------------- kallm@platinum.com or 100732.511@compuserve.com http://www.platinum.com Opinions are mine own, may be not PLATINUMs