Re: [U2] copying files in Unix from one IBM AIX computer to another IBM AIX computer
Thanks all for everyone's input! We added a trio of sync commands after every uv -admin -L, and that seemed to do the trick. We had no copy errors. We'll look into the other solutions (rcp -p, and jfs2) and let you know of any improvements. -- Louie --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] copying files in Unix from one IBM AIX computer to another IBM AIX computer
Louie, I'd also recommend the rcp -p, for remote copy, this is faster than cp and the -p preserves permissions. "Louie Bergsagel" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 02/04/2008 04:23 PM Please respond to u2-users@listserver.u2ug.org To u2-users@listserver.u2ug.org cc Subject [U2] copying files in Unix from one IBM AIX computer to another IBM AIX computer I'm trying to copy UniVerse files (all types) from one computer to another using an NFS mount and the Unix cp command, but am getting damaged files because they are in use. They are large files, between 4 and 22 gigs, some hashed, some dynamic, some directories. I tried to suspend UniVerse and then copy one file or directory, then unsuspend, but that hasn't helped. I am wondering if I need to pause a minute or so between the suspend (uv -admin -L) and the copy? In other words, is suspend immediate, or does it finish all the current writes and then pause? -- Louie in Seattle --- 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/
RE: [U2] copying files in Unix from one IBM AIX computer to another IBM AIX computer
If business data integrity is a major concern, then you also need to ensure you business processing is complete and (ideally) - shutdown the UniVerse environment prior to any manipulation of UV database files using third-party/OS tools (rm, cp, rcp, scp, mv, tar, etc, etc). For high-availability systems, stopping UV isn't an feasible option for daily snapshot backups. Caution needs to be exercised at the target end (for your backup) as well. Especially if you're overwritting existing disk backups which may be in use, etc. Then you will get logical file corruptions, especially if dealing with open dynamic files. Hence, extreme care is need for the backup and restore of dynamic files. Also be aware that UniVerse files with indices need to have 'SET.INDEX' run against them post-restore (if in a complete different path), if you're going to access the backup version (and want to use the correct index AND stop corrupt of your live version if co-located on the same host:)). Regards, David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dan Fitzgerald Sent: Tuesday, February 05, 2008 8:57 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] copying files in Unix from one IBM AIX computer to another IBM AIX computer After you issue the dbpause, drop to aix as root and do a few sync commands, thusly: # sync # sync # sync I usually give it a few seconds in between issuing the commands, but when I script it, it's "sync; sync; sync", so there's probably no reason to wait in between. This flushes all pending writes to persistent memory (for our purposes, disk). -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Louie Bergsagel Sent: Monday, February 04, 2008 3:56 PM To: u2-users@listserver.u2ug.org Subject: [U2] copying files in Unix from one IBM AIX computer to another IBM AIX computer I'm trying to copy UniVerse files (all types) from one computer to another using an NFS mount and the Unix cp command, but am getting damaged files because they are in use. They are large files, between 4 and 22 gigs, some hashed, some dynamic, some directories. I tried to suspend UniVerse and then copy one file or directory, then unsuspend, but that hasn't helped. I am wondering if I need to pause a minute or so between the suspend (uv -admin -L) and the copy? In other words, is suspend immediate, or does it finish all the current writes and then pause? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] copying files in Unix from one IBM AIX computer to another IBM AIX computer
Louie Bergsagel wrote: I'm trying to copy UniVerse files (all types) from one computer to another using an NFS mount and the Unix cp command, but am getting damaged files because they are in use. They are large files, between 4 and 22 gigs, some hashed, some dynamic, some directories. I tried to suspend UniVerse and then copy one file or directory, then unsuspend, but that hasn't helped. I am wondering if I need to pause a minute or so between the suspend (uv -admin -L) and the copy? In other words, is suspend immediate, or does it finish all the current writes and then pause? -- Louie in Seattle --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ If you are using jfs2 filesystems you can create snapshots (man snapshot) then copy from the snapshot to your other system. I recommend rsync for the copy also if you wanted to avoid NFS. You should still quiesce the database, though. But it would reduce your downtime to seconds, potentially. It boils down to this... stopud (or dbpause) create snapshots mount snapshots startud (or dbresume) copy at your leisure remove snapshots I've never used dbpause, probably because the thought of many many transactions being buffered until dbresume scares me. Louis --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] copying files in Unix from one IBM AIX computer to another IBM AIX computer
After you issue the dbpause, drop to aix as root and do a few sync commands, thusly: # sync # sync # sync I usually give it a few seconds in between issuing the commands, but when I script it, it's "sync; sync; sync", so there's probably no reason to wait in between. This flushes all pending writes to persistent memory (for our purposes, disk). -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Louie Bergsagel Sent: Monday, February 04, 2008 3:56 PM To: u2-users@listserver.u2ug.org Subject: [U2] copying files in Unix from one IBM AIX computer to another IBM AIX computer I'm trying to copy UniVerse files (all types) from one computer to another using an NFS mount and the Unix cp command, but am getting damaged files because they are in use. They are large files, between 4 and 22 gigs, some hashed, some dynamic, some directories. I tried to suspend UniVerse and then copy one file or directory, then unsuspend, but that hasn't helped. I am wondering if I need to pause a minute or so between the suspend (uv -admin -L) and the copy? In other words, is suspend immediate, or does it finish all the current writes and then pause? -- Louie in Seattle --- 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/
RE: [U2] copying files in Unix from one IBM AIX computer to another IBM AIX computer
Louie, After you suspend the database, you need to do an AIX sync in order to flush any writes that are still sitting in memory. That resolved a similar issue for us. HTH Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Louie Bergsagel Sent: Monday, February 04, 2008 2:56 PM To: u2-users@listserver.u2ug.org Subject: [U2] copying files in Unix from one IBM AIX computer to another IBM AIX computer I'm trying to copy UniVerse files (all types) from one computer to another using an NFS mount and the Unix cp command, but am getting damaged files because they are in use. They are large files, between 4 and 22 gigs, some hashed, some dynamic, some directories. I tried to suspend UniVerse and then copy one file or directory, then unsuspend, but that hasn't helped. I am wondering if I need to pause a minute or so between the suspend (uv -admin -L) and the copy? In other words, is suspend immediate, or does it finish all the current writes and then pause? -- Louie in Seattle --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material not intended for Public use. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is strictly prohibited. If you received this communication in error, please notify the sender and delete the material from any and all computers or devices. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] copying files in Unix from one IBM AIX computer to another IBM AIX computer
I tried suspend the other day and was surprised to find that if you suspended the database while a lock was present it preserved the lock making it stop a copy waiting for the lock to be released. This is on UV 10.1.12. So I'm not surprised that it could cause other problems. You need to get everyone to stop updating and releasing all locks before setting the suspend. Jerry Banker > -Original Message- > From: Louie Bergsagel [mailto:[EMAIL PROTECTED] > Sent: Monday, February 04, 2008 2:56 PM > To: u2-users@listserver.u2ug.org > Subject: [U2] copying files in Unix from one IBM AIX computer to > another IBM AIX computer > > I'm trying to copy UniVerse files (all types) from one computer to > another > using an NFS mount and the Unix cp command, but am getting damaged > files > because they are in use. They are large files, between 4 and 22 gigs, > some > hashed, some dynamic, some directories. > > I tried to suspend UniVerse and then copy one file or directory, then > unsuspend, but that hasn't helped. > > I am wondering if I need to pause a minute or so between the suspend > (uv > -admin -L) and the copy? In other words, is suspend immediate, or does > it > finish all the current writes and then pause? > > -- Louie in Seattle > --- > 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] copying files in Unix from one IBM AIX computer to another IBM AIX computer
I'm trying to copy UniVerse files (all types) from one computer to another using an NFS mount and the Unix cp command, but am getting damaged files because they are in use. They are large files, between 4 and 22 gigs, some hashed, some dynamic, some directories. I tried to suspend UniVerse and then copy one file or directory, then unsuspend, but that hasn't helped. I am wondering if I need to pause a minute or so between the suspend (uv -admin -L) and the copy? In other words, is suspend immediate, or does it finish all the current writes and then pause? -- Louie in Seattle --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/