RE: Changing triggers

Every night we recreate the data queue.  IBM says to occasionally recreate the data queue because it grows in size and never gets any smaller, even though the entries are removed.  The recreation CLLE ends all the jobs using the data queue (by sending an entry that says '*END'.  Next it gets the data queue attributes, and determines if there are any entries in the data queue.  A new data queue with the same attributes and name are created in QTEMP.  If there were any entries, it reads the entries from the production data queue and puts them in the data queue in QTEMP. Then the production data queue is deleted.  Next the data queue in QTEMP is moved to the production library and the programs using the data queue is restarted.  Any more questions, let me know.

-----Original Message-----
From:   Emilio Padilla Taylor [SMTP:epadilla@amigo.net.gt]
Sent:   Monday, April 03, 2000 3:12 PM
To:     RPG400-L@midrange.com
Subject:        Re: Changing triggers

RE: Changing triggers
Michael,
I tried this approach in v3r2 but the *dtaq sometimes got  "%%$##"#$" after
sometime of use :) (15K to 20K messages) and the clrdtaq command didn't
always work, so we used to delete and recreate the dtaq in every IPL.  That
was ok on a CISC system, we did an IPL every 3 days anyway. Now in v4r3 (My
actual release) the *dtaq is more reliable, but still having some problems
once in a while, mainly because we don't IPL as often as we use to.   How
are you dealing with this problem?

Emilio Padilla

----- Original Message -----
From: Schlemme, Michael C.
To: 'RPG400-L@midrange.com'
Sent: Lunes 27 de Marzo de 2000 03:17 PM
Subject: RE: Changing triggers




Jim,
We use several methods for handling triggers.  One method uses a trigger on
FILEA (not it's real name, HA HA).  The trigger program (RPGLE) receives the
trigger buffer and sends the data to a data queue.  PGMA (RPGLE, not it's
real name) is a never ending program waiting for an entry to arrive on the
data queue.  One advantage to this method is you can start multiple PGMA's
waiting on the same data queue.
Another method sends the trigger buffer data to a data queue being monitored
by a never ending CLLE program.  The CLLE program receives the entry, looks
in the trigger buffer information area, and calls the appropriate program to
process the buffer based on the file name.
Still another method places the trigger buffer data from multiple files
files into a single, keyed data queue.  Many different programs are waiting
to receive data from this data queue.  The key to the data queue entry is
the program name to process the entry.
-----Original Message-----
From:   Scott Mildenberger [SMTP:Smildenber@Washcorp.com]
Sent:   Monday, March 27, 2000 11:23 AM
To:     'RPG400-L@midrange.com'
Subject:        RE: Changing triggers
Jim,
To accomplish this we made the trigger programs do nothing but call another
program passing the parms to it.  This additional layer allows us to change
the programs that are actually doing the work whenever we want.
Scott Mildenberger
> -----Original Message-----
> From: Nelson, Jim   (RCIS) [SMTP:Jim.Nelson@RCIS-NET.COM]
> Sent: Monday, March 27, 2000 8:20 AM
> To:   'MIDRANGE-L@midrange.com'
> Subject:      Changing triggers
>
> In our development environment, we are changing SOME trigger on SOME file
> almost daily.  To make such a change, the file that trigger is based on
> must
> not have any locks.  This has become unworkable with the number of
> developers and functional test people involved.
>
> We are talking about creating completely generic triggers to call a stored
> procedure which will either run the activity intended or call one or more
> other stored procedures.  When a change was needed it would be made to
> that
> front-end stored procedure.
>
> Before we get too deep into this, it would be nice to know if there are
> any
> 'gotchas'.
>
> Has anybody else gone down this road?  Has it worked?  Anything we should
> keep in mind?
>
> Thanks,
> JN
>
+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator:
david@midrange.com
+---




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