Page 1 of 1

recover from imagecopy

PostPosted: Wed Mar 23, 2011 1:07 pm
by makkena
In what case the log is applied to the DB2 objects during recover of a tablespace using imagecopy.pls help

Re: recover from imagecopy

PostPosted: Wed Mar 23, 2011 1:16 pm
by BillyBoyo
If you want an answer, describe the situation as fully as possible. What you are trying to do, what you hoped to achieve, the error messages which indicate a discrepency between the two, edt.

Re: recover from imagecopy

PostPosted: Wed Mar 23, 2011 2:06 pm
by makkena
thanks for the reply.The situation is with the tablespace logged attribute
1)taken a full imagecopy
2)inserted 2 rows
3)recovered from full imagecopy
i tried this and in this case the 2 inserted records were ignored.
i have studied somewhere that the log will be applied after recovery.In which case the log will be applied when we recover the tablespace with imagecopy.Please help

Thanks in advance.

Re: recover from imagecopy

PostPosted: Wed Mar 23, 2011 2:46 pm
by BillyBoyo
Well, I'm guessing it wouldn't be automatic, as sometimes you'd just want to be back at your previous point. Don't you have any DB2 support onsite? I'd try them.

Re: recover from imagecopy

PostPosted: Wed Mar 23, 2011 3:08 pm
by GuyC
It's all about how you did your step 3)
TOCOPY / TOLOGPOINT / ...
reread IBM administration guide about recovery.