RE: is this the tremulous trigger truth ??

Have you considered using the trigger program to send a dataqueue message; a
server program can monitor the queue and do the additional processing for
you - blocking should then be back in the frame.  

With a little more work, you could have a single program monitoring the
dataqueue, passing the requests to an array of slave programs - potentially
capable of much higher volumes.

Another possibility is to have the trigger program submit the update into a
job queue to run as an independent batch job.

If blocking is an important issue for performance, side-stepping the trigger
program constraint should not be too hard.

Jeffrey E. Bull
OS400 Software Support Consultant

IBM Certified iSeries System Design Specialist
IBM Certifiied iSeries System Implementation Specialist
IBM Certified AS/400 System Administrator 

tel.      +44 [0] 149 454 9533               swb.   +44 [0] 149 454 9400
mbl.     +44 [0] 786 750 4961               fax.    +44 [0] 149 454 9454
web.     http://www.itm-group.co.uk
 
ITM Group Ltd, Latimer Square, White Lion Road, Amersham, Buckinghamshire,
HP7 9JQ, United Kingdom


-----Original Message-----
From: Marco Facchinetti [mailto:facchinetti@xxxxxxxxx]
Sent: 13 June 2003 09:03
To: Midrange Systems Technical Discussion
Subject: Re: is this the tremulous trigger truth ??


Consider using journal.
I found it very efficient and, just my opinion, more
flexible.

1 - You have an indipendent job doing the sync.
2 - In case of program bugs (you know sometimes...) any
action is still possible
3 - Better performance writing the original file

Of course you use more disk space, but just temporary.

Just my opinion..
Marco 
--- Tim Truax <truax@xxxxxxxxxxxx> wrote:
> Hey all,
> I work in a massive 400 shop that moves boo-koo data all
> over the place.
> I have a process that runs on a host-400 and reads a DDM
> file that points to
> the remote-400 file.
> This process reads the remote-400 file and does minimal
> data massaging and
> then just writes/updates the record read to a file on the
> host-400.
> The objective of this process is to take 3.8 million
> records from the
> remote-400 to the host-400 on a daily basis as quickly as
> possible.
> Someone wants to apply a trigger on the host-400
> receiving file that will
> perform another record addition to another host-400 file
> when a record
> addition occurs to the initial/original host-400 file.
> 



__________________________________
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com
_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.


________________________________________________________________________
This e-mail has been scanned for all viruses by ITM. The
service is powered by MessageLabs. For more information on a proactive
anti-virus service working around the clock, around the globe, 
email marketing@xxxxxxxxxxxxxxx
ITM - Managing Communication and Information through technology
Company registration number - 3783433
________________________________________________________________________


DISCLAIMER

Any opinions expressed in this email are those of the
individual and not necessarily the Company. This email
and any files transmitted with it, including replies and
forwarded copies (which may contain alterations) 
subsequently transmitted from the Company, are 
confidential and solely for the use of the intended recipient. If you are not 
the intended recipient or the 
person responsible for delivering to the intended recipient, 
be advised that you have received this email in error and
 that any use is strictly prohibited.

If you have received this email in error please notify the IT
manager by telephone on +44 (0)870 871 2233 or via 
email to Administrator@xxxxxxxxxxxxxxx, including a copy
of this message. Please then delete this email and 
destroy any copies of it.

________________________________________________________________________This 
e-mail has been scanned for all viruses by ITM. The
service is powered by MessageLabs. For more information on a proactive
anti-virus service working around the clock, around the globe, 
email marketing@xxxxxxxxxxxxxxx
ITM - Managing Communication and Information through technology
Company registration number - 
3783433________________________________________________________________________