Hello Terry...
My understanding is that the journal has to be kept to a certain size
because of the sheer volume of data being held in it. I believe at last
check it held about 4 years worth of information, for all of our
cross-border clients (that comes out to around 30000 on average). We are
also constantly upgrading our disk capacity and even then we are constantly
pushing the 90% threshold so the volume of data is constantly increasing as
new clients are picked up. I do not know if there is any journal
programming available to retrieve the data needed (it is not an area that I
am assigned to cover, though I'd not mind doing the work if given
permission).
The log file however, being much smaller, could be allowed to build up the
required minimum amount of information without chewing up huge amounts of
disk space. It is wanted because although we keep track on the various
records about the last activity, it is not truly historical. It is only a
snapshot of the last activity, and the auditors do not want that. In a
perfect world, I'm sure the journalling would be the option to go with.
Anyone got a perfect world they'd like to rent?...:)
Have a good day.
Blake Moorcroft
Developer - Corporate
Russell A. Farrow Limited
1980 Ambassador Drive, PO Box 333, Windsor, Ontario N9C 3R4
Bus: 519-966-3003 ext. 566, Fax: 519-966-9870
blake.moorcroft@xxxxxxxxxx
"Terry Anderson"
<terrya@citation.
net> To
Sent by: <rpg400-l@xxxxxxxxxxxx>
rpg400-l-bounces@ cc
midrange.com
Subject
RE:dentifying who deleted records -
11/13/2008 10:18 trigger programs
AM
Please respond to
RPG programming
on the AS400 /
iSeries
<rpg400-l@midrang
e.com>
Blake,
You should be able to retrieve the user by doing something like:
D USERID S 10 INZ(*USER)
Then write the variable USERID to your file.
Here is an article I found on how to tell what program caused your
trigger to fire.
http://www.tylogix.com/Articles/TriggerTechniques.htm#Trigger_Firing_Pro
gram
I am curious about something though. I am assuming that you will be
writing this information to a file. Won't you run into the same storage
problems with the file that you would with a journal? I know you said
that this would be for deleted records, but don't the auditors want to
know about any change to a record? We are a privately held company so I
know very little about sox requirements.
Terry Anderson
Programming Manager
Citation Corporation
Switchboard 1.251.867.5481 ext 212
Direct Line 1.251.809.2312
Fax 251.867.0525
Cell 1.251.363.4975
message: 2
date: Thu, 13 Nov 2008 09:35:54 -0500
from: Blake.Moorcroft@xxxxxxxxxx
subject: RE: Identifying who deleted records - trigger programs
The use of the journals for data retrieval is being
investigated by another developer. However, there are
considerations about how long the data in the journals is
available due to the volume of data being processed. The
auditors are looking for control over one file and
governmental regs require stored data to be *immediately*
available for a period of no less than 7 years (and
displeasing a government auditor who can yank your operating
license immediately is not conducive to business operations).
The journals that would encompass this file also contain
record changes on close to 90 other files. While it would
be a preferred option, it may not be a viable option.
So, to cover the bases, I'm assigned to check the option of
triggers, which leads back to the original question of user
and program identification from inside a trigger event.
Have a good day.
Blake Moorcroft
Developer - Corporate
Russell A. Farrow Limited
1980 Ambassador Drive, PO Box 333, Windsor, Ontario N9C 3R4
Bus: 519-966-3003 ext. 566, Fax: 519-966-9870
blake.moorcroft@xxxxxxxxxx
--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
http://archive.midrange.com/rpg400-l.
midrange.com
