Database recovery from Journals.

160 pts.
Tags:
AS/400 journaling
Journaling
MSGW
Hi experts,

I would like to know more about the Journaling in AS/400.

If one file is being journaled and due to error or worng replied to MSGW the job got cancelled.

In this case,I need to retrieve all the original recods of that file.

Could you please share what are the setps to retrieve the original records from that Journal.

Thanks,

Samul



Software/Hardware used:
Software

Answer Wiki

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

The APYJRNCHG command can be used to restore the file to it’s orignal values.
There are certain restrictions. You can find them by doing an F4 on the APYJRNCHG command then doing an F1.
Also here is a link to IBM info on Journal Management.

http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp

*
If this is not possible, you can use RTVJRNE to build a file of all the jouirnal records and then write a program to use whatever data you need.

Discuss This Question: 2  Replies

 
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
  • philpl1jb
    To "roll-back" removing entries from the current dbf use RMVJRNCHG To "roll-forward" after restoring an earlier verions of the dbf use APYJRNCHG. Phil
    49,980 pointsBadges:
    report
  • philpl1jb
    Using Commitment control with the RPG can cause the table(s) to automatically roll-back on any error up to the time your program commits the change. Phil
    49,980 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