Stuart, We have the same issue when copying files from AIX to Linux or vice-versa, if there are triggers attached. Even dropping the trigger does not work. The only work around that we use is to create a new copy of the file on the originating server, then send that file instead. I have been told that deleting the trigger on the orignal server will work on the latest version of UV, but have not tried it yet.
In regards to backup, we use uvrestore and backup as a normal user. To be able to do that, we had to modify the UV.BACKUP item in file UV.ACCESS (in the UV.ACCONT). We added the user id in attribute 1 and "WRITE" in attribute 2. I also noticed that you must have write permission to be able to backup a file. Eg... SELECTed record name = "UVBACKUP". 2 lines long. ----: P 0001: uvadmrootNT AUTHORITY\systemkkbkupbernardl 0002: READWRITEWRITEWRITEWRITE Bottom at line 2. Regards -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Boydell, Stuart Sent: Wednesday, 17 September 2008 6:33 PM To: u2-users@listserver.u2ug.org Subject: [U2] cannot fnuxi a file with a trigger... First question, just wondering how others get around this issue. We're copying files from Aix (Risc) production to Linux (x86) scratch for use in dev and test environments. The files which have triggers on them are interpreted as sql files and cannot be fnuxied. For the moment I am just copying the files locally (without the trigger) and then copying & fnuxi them. This gets laborious, any other suggestions? Second question. If I try to use uvbackup on anything I get an error like: Warning: Access list denial: Function UVBACKUP, File VEND.DETS000 WARNING: Unable to open file 'VEND.DETS000' for reading. File not saved! This happens on files I own and others I have rw permissions on ... do you need to run uvbackup as root?!! Cheers, Stuart Boydell ********************************************************************** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this communication in error, please reply to this e-mail to notify the sender of its incorrect delivery and then delete it and your reply. It is your responsibility to check this email and any attachments for viruses and defects before opening or sending them on. Spotless collects information about you to provide and market our services. For information about use, disclosure and access, see our privacy policy at http://www.spotless.com.au Please consider our environment before printing this email. ********************************************************************** ------- 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/