Re: Where to place trigger programs?

[Gord Hutchinson <gordm1@xxxxxxxxxxxxxxx>]

Thanks But I don't see where I'm having any real problems with triggers.
Our CLs are already set up to do the RMVPFTRG.

My point was *what* does IBM recommend be in the file library?  The trigger
program object or the trigger as defined on the ADDPFTRG.  


Gord

>On Fri, 17 Feb 2006 09:22:12 -0500, rob@xxxxxxxxx wrote:

>V5R4 has some options to help you there Gord.
>
>Rob Berendt
>-- 
>Group Dekko Services, LLC
>Dept 01.073
>PO Box 2000
>Dock 108
>6928N 400E
>Kendallville, IN 46755
>http://www.dekko.com
>
>
>
>
>
>Gord Hutchinson <gordm1@xxxxxxxxxxxxxxx> 
>Sent by: midrange-l-bounces@xxxxxxxxxxxx
>02/17/2006 08:18 AM
>Please respond to
>Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
>
>
>To
>Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
>cc
>
>Fax to
>
>Subject
>Re: Where to place trigger programs?
>
>
>
>
>
>
>>On Fri, 17 Feb 2006 08:10:32 -0500, "Wilt, Charles" <CWilt@xxxxxxxxxxxx> 
>wrote:
>
>>There are issues if you restore a file that was save with a trigger
>>attached and the trigger is in another library.
>>
>>As I recall, IBM recommends placing the trigger in the same library as
>>the file.
>>
>
>I'd like some clarification on this recommendation.
>
>I have always put our trigger program objects in our normal object 
>library.
>On the ADDPFTRG command is the TRGLIB parm which I've always left as the
>default *FILE.
>
>I have never had a problem restoring files.  I have done many DR tests 
>since
>we started using triggers and just recently did a restore onto a new 520.
>
>Nor have I ever had a problem with CRTDUPOBJ of a file with a trigger.  In
>fact we have had to do a RMVPFTRG after doing the CRTDUPOBJ because the
>triggers were being fired after record were written to or updated in the
>duplicate file.
>
>
>Gord
>
>
>-- 
>Gord Hutchinson
>Database Administrator, IT
>TST Overland Express
>ghutchinson@xxxxxxxxxxxxxxx
>905-212-6330
>fax: 905-602-8895
>-- 
>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.