RE: Where to place trigger programs?

Gord,

IIRC, the problem is when a trigger program is in a library with a name
that causes it to be restored after the library with the file.

The OS wants the trigger program to exist before it restores the file.
Kind of like the problems caused when you restore a library containing a
logical file before restoring the library containing the physical.

HTH, 

Charles Wilt
--
iSeries Systems Administrator / Developer
Mitsubishi Electric Automotive America
ph: 513-573-4343
fax: 513-398-1121
  

> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx 
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Gord Hutchinson
> Sent: Friday, February 17, 2006 8:19 AM
> To: Midrange Systems Technical Discussion
> 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.
> 
>