RE: Trigger Processing Question

Jeff,

Fire off an entry into a data queue from the trigger program. Have another process already running which is monitoring the queue and processes the entry to call the other program to do some other processing. It's possible for you to shut down the process and restart it to make changes to the other program. As long as the data queue is available the trigger program can continue to fire entries into the queue.

I wouldn't do any checking for a data queue or process in the trigger program. Neither would I submit a job or call the program from the trigger program. You want to reduce as much as possible any possibility of an error or delay with the trigger program.

If you want to make changes to the trigger program you should use the Trigger Mediator pattern.

Paul Morgan

Principal Programmer Analyst
IT Supply Chain/Replenishment


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Jeff Young
Sent: Friday, June 17, 2011 10:27 AM
To: midrange-l@xxxxxxxxxxxx
Subject: Trigger Processing Question

V6R1
I have a trigger program that is going to be called thousands of times during
the day.
This program will test some fields in the old and new record and then fire off a
program to do some other processing if they are changed.
At this time this is the only trigger being used, so the Trigger Mediator
program is overkill.
I want to be able to make changes to the program doing the proessing if needed.
I will initialy call a program to test if  a data queue exits and if the
processing job is already active and waiting for a message.
If not, the program will create the data queue and then submit the processing.

What is the best method to call this program?
 Dynamic call from the Trigger?
Submit job to batch ?
Some other method?

All suggestions will be appreciated.

Thanks,
 
Jeff Young
Sr. Programmer Analyst