To: U2 Users List
Subject: Re: [U2] Triggers and Account Copy
...if it's a 24/7 file (ie you can't drop the trigger as it would
compromise data integrity) you can edit the file header once it has been
restored. It's fiddly but possible.
We do it this way when using a snap copy
rguson.com
Sent: Tuesday, June 02, 2009 6:49 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Triggers and Account Copy
Triggers on files usually call subroutines that do something, update an audit
file or check for consistency or add an item to a queue, for example.
As long as the trigger
Triggers on files usually call subroutines that do something, update an audit
file or check for consistency or add an item to a queue, for example.
As long as the trigger subroutines are accessing local files in the test
environment and the main trigger subroutines are cataloged globally, you sho
Mark Eastwood wrote:
Exactly,
dropping the triggers is
something I’d like to avoid.
I’d much
rather copy and then “fix”
in the new account. I was hoping there were commands to facilitate
(similar to
SET.INDEX for Indexes).
Remember that the
logic you put in the DELETE
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Boydell,
Stuart
Sent: Monday, June 01, 2009 8:09 PM
To: U2 Users List
Subject: Re: [U2] Triggers and Account Copy
...if it's a 24/7 file (ie you can't drop the trigger as it would
compromise data in
Stuart Boydell
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Jenkins
Sent: Tuesday, 2 June 2009 07:23
To: 'U2 Users List'
Subject: Re: [U2] Triggers and Account Copy
If you are using uvbackup / uvrestore drop the tr
Mark,
UV stores the location of the index(es) in the file header, so your "test"
files would still point back to the original indexes, and potentially
corrupt them as you changed the test data.
The SET.INDEX verb allows you to view/update the index location path. I
think you should be able to use
If you are using uvbackup / uvrestore drop the triggers first.
Regards
JayJay
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mark Eastwood
Sent: 01 June 2009 20:19
To: U2 Users List
Subject: [U2] Triggers and Account Copy
Uv
Uv 10.2 RH
I need to copy a "live" account to a "test" account (i.e. cp -r live
test), but the live account has Triggers setup on several files. Should
I drop these triggers before copying? Or can they be left alone and
work in the new account just fine?
I know indexes require some cleanup after