Home > IT Answers > AS/400 > Database recovery from Journals.
Samule400
160 pts.
 Database recovery from Journals.
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
ASKED: November 6, 2009  12:27 PM
UPDATED: November 6, 2009  6:45 PM
RELATED QUESTIONS
Answer Wiki:
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.
Last Wiki Answer Submitted:  November 6, 2009  3:07 pm  by  CharlieBrowne   32,945 pts.
All Answer Wiki Contributors:  CharlieBrowne   32,945 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

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

philpl1jb
 44,220 pts.
 

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

philpl1jb
 44,220 pts.