Database recovery from Journals.
60 pts.
0
Q:
Database recovery from Journals.
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: Nov 6 2009  12:27 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
0
6350 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
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 Answered: Nov 6 2009  3:07 PM GMT by CharlieBrowne   6350 pts.
0
0
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Philpl1jb   24510 pts.  |   Nov 6 2009  6:43PM GMT

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   24510 pts.  |   Nov 6 2009  6:45PM GMT

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

 
0