Re: Performance hit with trigger program

Manager: We cannot use journaling; disk usage is over 90%.
Dan: But Dieter says 'There is never ever a valid reason not turning on
journal'!
Manager: Oh, I see. Well, go ahead, then.

Dieter, I don't think throwing such an absolute statement at Dan without
any underpinning is very helpful. Before he can convince his manager, you
will first have to convince him why you think there is no valid reason.

Joep Beckeringh
systeemontwerper
Pantheon Automatisering B.V.
Heerenveen

Postadres
K.R. Poststraat 101-2
8441 EN Heerenveen
T. 0513 657 357
F. 0513 654 695

info@xxxxxxxxxxxxxxxxxxxxxxxxxx
www.pantheon-automatisering.nl
KvK 01055135


"RPG400-L" <rpg400-l-bounces@xxxxxxxxxxxx> wrote on 09-04-2016 10:11:46:

From:

"D*B" <dieter.bender@xxxxxxxxxxxx>

To:

"RPG programming on the IBM i / System i" <rpg400-l@xxxxxxxxxxxx>

Date:

09-04-2016 10:12

Subject:

Re: Performance hit with trigger program

<Alan>
Use a named activation group for best performance and assuming all this
program is going to do is write to data queue.
</Alan>

... more important than performance is correctness and this approach

(named

Activationgroup and asynchronous work for a trigger making

writes/updates to

other tables) is not transaction safe.

<Dan>
Oh, and for those who will inevitably ask, I was told that we cannot

turn

on journaling. This is my second week here, and I don't have enough

clout

to delve into the why
</Dan)

There is never ever a valid reason not turning on journal!!!

D*B

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

Please contact support@xxxxxxxxxxxx for any subscription related

questions.