Hi.
I need to mirror a set of my database data, that is create a database
which acts as a buffer in front of the real one.
We have in our DB2 database data which has been created over the last
100 years or so, and is obviously huge amount of data. All normal
operation is done though on data which has been created over the last
30 days or so.
Is it possible to create database which only holds data created over
the last 30 days. Further more all inserts, updates and deletes should
affect both the huge database and also the small one. Any suggestions
would be greatly appriciated.