Home > IT Answers > AS/400 > Is AS/400 journal time JOTIME accurate?
philpl1jb
44,060 pts.
 Is AS/400 journal time JOTIME accurate?
AS/400 jobs, AS/400 Journal Time, AS/400 journaling, JOTIME
I have three jobs that ran today and wrote records to the same file. JOTIME showed all 9 writes and 1 update @ 12:37:25 for job1. Job 2 with 5 writes at 2:38:00. Job 3 with 4 writes and an update all at 12:38:27. The program logic says that each job should have deleted the existing records then done it's writes and updates. No records were deleted, so I'm wondering if it's because they really weren't in the file when the jobs attempted to delete them and when JOTIME says they were. No commitment control, records are accessed and written through the only logical.

Software/Hardware used:
ASKED: January 20, 2009  9:06 PM
UPDATED: March 6, 2009  3:01 PM
RELATED QUESTIONS
Answer Wiki:
INteresting. I guessed the time correction! Couple of points - times are to 5 places of milliseconds, so the precise sequence can be found. - Are you displaying *ALL entries in the journal? If you are satisfied that there is no more information in the journal which is not being displayed, then it's telling the truth. *********************** Thanks The problem which I was working on in January was 1. Job1 writes some records 2. Job2 should delete those records and write some new ones 3. Job3 should delete any record from Job1 or Job2 and write new ones By the times the journal says that they did their stuff in the order 1 - 2 - 3. I think they must have overlapped, job 2 must have looked for records to delete before they were visible from job1 and job3 must have looked for records to delete before they were visible from jobs 1 and 2. There is very little logic between the code to delete and the code to write but something happened. Apparently it hasn't happend since January so I'll put it down as a fluke. Anyway, I had hoped that the journal times would show the overlap but didn't Phil
Last Wiki Answer Submitted:  March 6, 2009  2:12 pm  by  Yorkshireman   5,505 pts.
All Answer Wiki Contributors:  Yorkshireman   5,505 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


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

 

Sorry — correction to time: Job 2 with 5 writes at 12:38:00.

philpl1jb
 44,060 pts.
 

If you look at the journal in it’s entirety without selecting out the particular file in question, you will see the sequence of the actula journal entries hitting the journal before hitting the database. This will tell you the real story.

Lovemyi

Lovemyi
 2,310 pts.