Is AS/400 journal time JOTIME accurate?

48,545 pts.
Tags:
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.
ASKED: January 20, 2009  9:06 PM
UPDATED: March 6, 2009  3:01 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

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

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • philpl1jb
    Sorry -- correction to time: Job 2 with 5 writes at 12:38:00.
    48,545 pointsBadges:
    report
  • Lovemyi
    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
    2,310 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following