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

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

Join the forum, it's quick and easy

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

Get Answers for all your queries on IBM i (AS/400).
PMS Information Systems
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Database recovery from Journals

Go down

Database recovery from Journals Empty Database recovery from Journals

Post  sivakumar 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 : 37
Location : Chennai

Back to top Go down

Database recovery from Journals Empty Re: Database recovery from Journals

Post  sivakumar 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 : 37
Location : Chennai

Back to top Go down

Database recovery from Journals Empty Re: Database recovery from Journals

Post  sivakumar Wed Jul 14, 2010 7:58 pm


sivakumar

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

Back to top Go down

Database recovery from Journals Empty Re: Database recovery from Journals

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

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