PMS Information Systems
Welcome to PMS Information Systems - IBM i (AS/400) Forum !!!

Get Answers for all your queries on IBM i (AS/400).

Database recovery from Journals

View previous topic View next topic Go down

Database recovery from Journals

Post  sivakumar on Wed Jul 14, 2010 7:55 pm

If one file is being journaled and due to error or wrong replied to MSGW the job got cancelled. In this case, I need to retrieve all the original recods of that file. What are the setps to retrieve the original records from that Journal?

sivakumar

Posts : 174
Join date : 2009-07-27
Age : 30
Location : Chennai

View user profile

Back to top Go down

Re: Database recovery from Journals

Post  sivakumar on Wed Jul 14, 2010 7:58 pm

The APYJRNCHG command can be used to restore the file to it's orignal values. There are certain restrictions. We can find them by doing an F4 on the APYJRNCHG command then doing an F1.

We can also use RTVJRNE to build a file of all the jouirnal records and then write a program to use whatever data we need.

sivakumar

Posts : 174
Join date : 2009-07-27
Age : 30
Location : Chennai

View user profile

Back to top Go down

Re: Database recovery from Journals

Post  sivakumar on Wed Jul 14, 2010 7:58 pm


sivakumar

Posts : 174
Join date : 2009-07-27
Age : 30
Location : Chennai

View user profile

Back to top Go down

Re: Database recovery from Journals

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum