RE: Triggers, Activation Groups, Performance

Bradley,

At 03:45 PM 1/21/99 -0600, you wrote:

>If you were to have your trigger program run in a unique AG, and you wanted
>to reclaim the AG after every call, I think you would actually see a
>decrease in performance since the unique AG (for example using *NEW) would
>have to be created, and then when done, reclaimed.  In your instance,
>reclaiming the AG is not an option since QILE AG is used for everything, and
>therefore would not be eligible to be reclaimed.

 I don't think that your last statement is accurate.  QILE has no special
magic.  It's just a default that IBM picked for named AGs.  There's nothing
that would restrict reclaiming it the same as any other AG.  An AG is
attached to a particular job.  Any other job firing the trigger will get a
new invocation of the program.  

 *CALLER would probably give you the best performance, especially noticable
in jobs that are doing very few updates, since a new AG doesn't have to be
created.

 -mark

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---