Hi Stuart The best way I've found is to actually zero the pointer in the file header to the location of the SICA block, effectively removing the trigger and constraint details, then running fnuxi. Not good.
Otherwise I have a utility program that builds a backup image of an account, set of accounts or specific files and recreates them on another platform, though that may be overkill. [AD] or you could download an eval copy of mvInstaller and use that to move stuff.. You'll get 10 days free use before you have to pay for it... [/AD] Regards Brian > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Boydell, Stuart > Sent: 17 September 2008 09:33 > To: [email protected] > 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 > [email protected] > To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
