Putting The Clock Back

[Hattusas]

Is it possible to restore a new database from its current position's a certain period of time(an hour,3 hours,15 minutes etc.) earlier interface?
We are backing up our db once in a day on early morning time and sometimes for example when our users make a great mistake that interferes the stability of data in the afternoon , we want to undo the operation but restoring the back up causes the whole data to be lost entered during the morning time.

Any methods for that?Thank you..

Salih Sipahi

 

[blom0344]

http://www-128.ibm.com/developerworks/db2/library/techarticle/pworld/0112mccluney.html

Does this get anywhere near your demand?

Ties Blom

 

[gregsimpson]

Hattusas,

you need to do a restore, then rollforward through the logs to a particular point in time. If there's a UOW spanning this period of time you'll be forced to go to that. Not read the link from ties other than the title and the title seems to cover what you need to do, so I'd go with that article.

If you need them I can post some specific instructions as to how we do this day to day in my place.

Greg

 

[Hattusas]

Thanks for your help. I was omitting the restore step.

 

[Hattusas]

As an addition..I have a question for my log files. When I decide to delete the logs older than a period of time e.g 3 months what steps should I do?
Is there any database configuration for that?

Salih Sipahi
Software Engineer.
City of Istanbul Turkey
s.sipahi@sahinlerholding.com.tr