Home > IT Answers > AS/400 > Receiving journal entries
pprasad123
0 pts.
 Receiving journal entries
OS/400, iSeries, i5, Security, Integration/Connectivity, Tools, tips and tricks, System monitoring, Printing, Backup & recovery
Hi,

I am new to AS400, so need some help in solving a problem. I have tried to some extent but things seem to be more complicated than I thought.

Problem Goal: receiving entries from a journal and putting them into a DB2 table in a predefined format(say Type5).

RCVJRNE command can be used to specify an exit program that will receive entries from the journal. From within this Exit program, I can open the pre-created DB2 table and write into it. But the main problem I am facing is how to maintain the last processed journal entry sequence number. It can happen that due to some reason my exit program completes or is killed. When I execute RCVJRNE command again, my exit program will receive all the entries from the beginning. I guess I need to call the RCVJRNE from within a CL program and maintain the sequence number on the disk, so that I can read it at the time the job is restarted. Also is there a way to make sure that if the job containing RCVJRNE is stopped somehow, it is automatically restarted and RCVJRNE is run. All required info can be got from the CL programming guide & iSeries Info center but seems to be too big to go through for a quick solution. Any suggestions will be greatly helpful.

Thanks,
P.Prasad
ASKED: Jun 22, 2005  5:55 AM GMT
UPDATED: June 24, 2005  12:26:59 AM GMT
RELATED QUESTIONS
hjkrop
0 pts.
Answer Wiki:
maybe you can take a look at

http://publib.boulder.ibm.com/iseries/v5r2/ic2924/books/sm04/c4153046.pdf

good luck

Rita
Last Wiki Answer Submitted:  Jun 23, 2005  6:54 AM (GMT)  by  hjkrop   0 pts.
To see other answers submitted to the Answer Wiki View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



 

Why not just keep the sequence number in your DB file. Before you add the record, chain with the sequence number. If the record is found, skip it. You can also store the last sequence number - either in a file or in a data area - and use it to control which journal entries you receive with the RCVJRNE command - one of the parms is starting sequence number.

As to automatically restarting the REVJRNE job:
1. Set a flag on the system(file or data area) showing the status of the job. Submit/Started/Completed.
2. Setup a scheduled job to run and check the flag. If it is not completed, resubmit the REVJRNE job. If it is started, check if the job is active. If not, resubmit it.

If you need more info, let me know.

I hope this helps.

Len Hrabar

LHrabar
 95 pts.
 

I’m not sure what you’re after. Are you trying to build a permanent record of the journal entries? If so, the Journal Receiver *JRNRCV is a better store — it can’t be changed whereas a DB2 table can be. We write programs that use RCVJRNE to build a work file and run then periodically run the report program. Then we simply pick a starting and ending point in time for which to receive the journal entries.

TheQuigs
 0 pts.
 

Hi All,

Thanks for the replies. I will implement your suggestions and get back if stuck again in some problem.

Thanks,
P.Prasad

pprasad123
 0 pts.