Recovery of PF data from journal

425 pts.
Tags:
AS/400 DB2
AS/400 journaling
Data Recovery
Hi All, Consider the case, some one has accidentally deleted all records in a PF and that file is Journaled, Is it possible to recovery the records from receiver attached. if so, how can we do it?

Answer Wiki

Thanks. We'll let you know when a new response is added.

First, if you have a backup copy of the file, you might need to restore from it.

To recover deletions of rows using a journal, you have two possible methods that depend on how the journalling was done.

If you started journalling as IMAGES( *BOTH ), then you can use RMVJRNCHG to run the deletions backwards to the time before the deletions started. This is a fairly easy and simple operation. For the most part, you only need to verify that you have the proper receivers available, that you specify the proper receiver (or receivers) and that you specify the correct start and end times.

But if you started journalling only with IMAGES( *AFTER ), then you must restore the file from before the deletions and use APYJRNCHG from the point in time of the save up to the point just before the deletions began.

An *AFTER image of a deletion contains no data. Therefore, the deleted row cannot be recovered from it. To restore deletions, you need *BOTH in order to have the “before deletion” row data available.

Tom

That last paragraph sounds scary. The answer, in Tom’s earlier paragraphs is YES YOU CAN and there are two ways to recover if you have before and after images but only one way to recover if you only have the after image

Phil

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • TomLiotta
    That last paragraph sounds scary. Maybe the most scary part is that IMAGES( *AFTER ) is the default. I'd prefer the other way around. Tom
    125,585 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following