|
I wonder also if commitment control is a factor here. Do the triggered updates need to be managed by the application's commit cycle? I know that we interrogate commit status in our external triggers, though we do not currently use commitment control in our apps... Eric DeLong Sally Beauty Company MIS-Project Manager (BSG) 940-297-2863 or ext. 1863 -----Original Message----- From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of Vernon Hamberg Sent: Saturday, December 17, 2005 3:21 PM To: Midrange Systems Technical Discussion Subject: Re: Trigger Question Jack I don't where they got that recommendation. The Redbook SG24-6503 entitled "Stored Procedures, Triggers and User Defined Functions on DB2 Universal Database for iSeries" has the following statement in the the Recommendations section of the External Triggers chapter (page 405 on the page, 423 in the PDF): >You may need to have your trigger programs run asynchronously, for >example, when you want to trigger a long running process which >should not keep the application from proceeding. For this purpose, >you might use the Submit Job (SBMJOB) command. In this case, >applications cannot expect any kind of feedback from the trigger execution. HTH Vern At 11:23 AM 12/17/2005, you wrote: >To All, > > > >A discussion of Triggers the other day got a little heated when one member >of the discussion said that IBM recommends that Trigger programs should not >be designed to SBMJOB jobs but rather should do all of the processing within >the bounds of the trigger program itself. Of coarse, as is almost always the >case in these types of discussions, references were very scares, and the >group of people quickly became polarized into pro and con camps. My search >of the literature did not provide me with any concrete evidence one way or >the other so I am turning to an excellent source of technical information to >get either literature references or personal experience stories to settle >this question in a friendly and logical fashion. The basic question: Should >Trigger programs when necessary be designed to Submit Jobs to complete >required processing. > > > >By the way, A very Merry Christmas holiday to all members. > > > >Jack Derham > >Direct Systems, Inc. > >-- >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.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.