File update

385 pts.
Tags:
AS/400
AS/400 journaling
AS/400 logs
Hi, Is there any way to know whihc program updated a specific record of a file without the journals IN as400?
ASKED: October 9, 2008  10:32 PM
UPDATED: August 21, 2010  10:20 AM

Answer Wiki

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

Hi,

In a word – No. Not without the journals.

Regards,

Martin Gilbert.

That is, there is no way to tell what program did it yesterday.
If you change the programs and file you could add a field for the chg program id, chgDt, chgUsr.
Or you could set up a trigger program to capture this data into a log file of your own.
Best answer is journaling.

Phil

=========================================================

A trigger on a file may interrogate the call stack to determine what program caused the update. It would almost certainly be a worse performer than a journal, and recording the information could take as much space as a journal entry.

Some people prefer triggers even though they don’t provide the guarantee of a journal entry nor the speed. I’ve never understood why someone would look for harder and slower ways of doing things that the system can do automatically.

And you could always replace every routing entry, prestart job and autostart job with ones that you create. The replacements would start job traces before transferring control to whatever program was originally in place for the entry. Then you’d have traces that could be searched for accesses to the file. The active program name would be available in the trace.

Tom

Discuss This Question:  

 
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

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