...Although, as the OP seems to be using it for transfer from AIX to Linux, it's almost the simplest way to have it do all the fnuxi-ing for you. Another gotcha to look out for with AIX-Linux (bigendian-littleendian) transfers using uvbackup is that it doesn't properly restore files with triggers. You either have to drop them before you do the backup or meddle with the file header after restore. Cheers. Stuart
-----Original Message----- I don't know of anyone who actually relies upon uvbackup/restore for their backup/restore strategy. Other than supposedly support "online" backups and checking file integrity - I would see it's relatively slow speed as another reason not to utilise it. Other DB vendors tools tend to suffer from similar such drawbacks as well... The only other comment I'd make is that you don't mention of your AIX rmt device block size was set to automatic or not. This may potentially be the cause of some of your issues? Regards, David -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Gregor Scott Sent: Tuesday, 3 May 2011 12:13 PM To: U2 Users List Subject: [U2] Limitations of uvrestore I have just finished some testing of uvbackup and uvrestore on AIX and Linux to see if there are areas to improve performance. The results were interesting, and somewhat alarming - see http://gdoesu2.wordpress.com/2011/05/02/facts-about-uvbackup-and-uvrestore/ for details. What I am interested in is: a) Do UV platforms other than AIX and Linux have similar issues with uvrestore? b) Does anyone use block sizes beyond 1mb for uvbackup and uvrestore? If so, what size and what impact does it have on backup performance? Thanks Gregor ************** IMPORTANT MESSAGE ***************************** This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. ************************************************************** _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
