Re: Calling Program information -- RPG400-L

I doubt the journal would get that large...

Think about it, assuming your Order file's record size + the journal
entry data totals 500 bytes.

At one update a second, a day's worth of journal entries takes only
(500*60*60*24) = 43,200,000 bytes or 43.2 Megs.

If you got 1GB of spare disk space, you've got room for more than 20
days of journals.

Actually, IBM has a calculator you use to determine space requirements:
http://publib.boulder.ibm.com/infocenter/iseries/v5r4/topic/rzaki/rzakisizecalc.htm

Performance might be more of an issue, since journaling without the
use of commitment control has a negative impact on performance. But
since you're only talking about a single file, I'd be willing to bet
you won't notice it.

Heck if it were me, I'd look at journalling all my important files.

I've worked for small shops, medium shops, and large shops;
journalling was used by all of them.

HTH,
Charles

On Thu, Mar 5, 2009 at 10:25 AM, Kesterson, Randy
<RPKesterson@xxxxxxxxxxxxxxxxxxx> wrote:

I thought about journaling but the file is our Order file and it's constantly being updated. The journal will get quite large quickly. I only want data in the file when I know I have found a problem. And, I may still go with journaling. Especially since it looks like the information I'm looking for isn't available without it.

Thanks for your input.
______________________________________________________________________________________________
Randy Kesterson, Information Services
Market Transport Services - a UTi Worldwide Company| 110 N Marine Drive | Portland, OR 97217 | USA
rpkesterson@xxxxxxxxxxxxxxxxxxx | D +1 503.978.4353 | O +1 503.283.2405 x353 | F +1 503.978.4392

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Bob P. Roche
Sent: Thursday, March 05, 2009 6:59 AM
To: RPG programming on the IBM i / System i
Subject: Re: Calling Program information

Why not just journal the file? It gives you program name, user, time, all
sorts of useful info for this type of problem.

From:
"Kesterson, Randy" <RPKesterson@xxxxxxxxxxxxxxxxxxx>
To:
<rpg400-l@xxxxxxxxxxxx>
Date:
03/05/2009 08:53 AM
Subject:
Calling Program information
Sent by:
rpg400-l-bounces@xxxxxxxxxxxx

Does anyone know if any of the "Information" data structures has the
name of the program, if any, that called the program you're in?

I'm going to put a trigger on one of the files in our system to save a
record in a separate file anytime a record is deleted or a specific
field within a record is blanked out. I'm tracking down the cause of
two separate issues here and it would be nice to be able to add a field
to the saved record that says what program called, or caused, this
trigger to run.

Thanks,

________________________________________________________________________
______________________
Randy Kesterson, Information Services

Market Transport Services - a UTi Worldwide Company| 110 N Marine Drive
| Portland, OR 97217 | USA
rpkesterson@xxxxxxxxxxxxxxxxxxx <mailto:rpkesterson@xxxxxxxxxxxxxxxxxxx>
| D +1 503.978.4353 | O +1 503.283.2405 x353 | F +1 503.978.4392

--
This is the RPG programming on the IBM i / System i (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.

--
This is the RPG programming on the IBM i / System i (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.

--
This is the RPG programming on the IBM i / System i (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.