We use UniData on HP Unix, so I am not sure how much of this will transfer over, but here are things we found:
1) Triggers must be globally cataloged. This means that if you have a development account on that same box, you have to play games if you want to make changes. We have both a development account and a staging account in addition to our LIVE account, so this was a real problem for us. To get around this problem, I moved all the code from the trigger into a 2nd, DIRECTly cataloged program, and had the original trigger do nothing but call the 2nd subroutine. This works VERY well. I think this is what Brian was saying. 2) You should also CLOSE all opened files that are in a trigger. We found out the hard way that triggers do not close files when they terminate (not sure why), and we quickly hit the max # of files problem. 3) Do NOT use triggers to build indexes. Use the native indexes, but just like triggers, use them sparingly and wisely. 4) You have to be root (or have root privileges) to put a trigger on a file. John Israel -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brian Leach Sent: Wednesday, October 08, 2008 4:54 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Universe Triggers One gotcha is that once a trigger is on there, you can't easily change/extend it unless your system has a downtime period in which everyone is logged out. For this reason on 24x7 sites I use a master trigger that can call subtriggers, held as a list in a parameter file. This means that a new subtrigger can be inserted, old subtriggers removed etc without having to log everyone out. Yes, it means an extra read and yes it is an imperfect solution in an imperfect world.. And of course remember you are running under transactional constraints when using triggers. Brian > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Mike Roosa > Sent: 08 October 2008 04:22 > To: u2-users@listserver.u2ug.org > Subject: [U2] Universe Triggers > > We are getting ready to implement triggers on a universe > system running under Windows Server 2003. I created a > trigger and tested it out and it appears to do exactly what > we need. My question is are there any gotchas or issues we > should be concerned about with triggers? Are there any > performance issues that anyone has seen related to triggers? > > Thanks, > Mike Roosa > ------- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
