I am working on creating a reporting database that customers can query.
The rpt database should include the records of the app database, but should not be pruned like the app database so it will include historical data.
Currently we are doing this through a once a day export/load process. However I want to take this down to 3-5 minutes. After changing the interval on the export/load I am beginning to wonder if this is the best way to do this. I think the constant loading on the database will bring in locking issues with the customers querying. So not sure if using export/import would be any better, or a DB2 SQL Replication that does not replicate deletes.