MVSFORUMS.com

LEO · Posted: Thu Feb 08, 2007 2:47 pm Post subject: Recovery to PIT

HI,

I have a DB2 update program that ran for some time and then abended due to some problem. Now I would like recover the tables to previous point in time, i.e before the update program's run. What should be done ?
Please advise
Thanks,
leo

kolusu · Posted: Thu Feb 08, 2007 5:26 pm Post subject:

LEO,

If your program has taken checkpoints/commits then you canNOT recover to the previous point. If the pgm has not taken any checkpoints/commits then once the pgm abended all the changes are ROLLED back automatically

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

LEO · Posted: Fri Feb 09, 2007 11:05 am Post subject:

Kolusu,
Thanks for your reply. If there is an image copy, can't we use RECOVER to LASTFULLCOPY statement. But is there a way to apply the log to reach the point before pgm starts. Please advise.

Thanks,
leo