I once tried RESIZE CONCURRENT on a file that had a high amount of reads happening to it, on Universe 10.3.4 on AIX. (This was when I was a RESIZE rookie).
Brought the company to its knees for most of the morning. I don't like it personally, but, that's just me. Worst part is, once you start it, you better not stop it, because it will break the file header and render the file pretty much useless. It also takes a lot longer to finish because of all the activity on the file too. Luckily for me, the file did not have a lot of writes that morning, and so I was able to restore from a previous nights backup. The system at the time did not have transaction logging or anything like that enabled. Never tried it again after that. Pretty much scarred me for life. On Tue, Mar 5, 2013 at 3:47 PM, Baakkonen, Rodney A (Rod) 46K < rodney.baakko...@cigna.com> wrote: > Have you used the Concurrent index build? The downside I have seen with > that is the speed. I have some files that are large and the concurrent > index build is very slow. So I only use the concurrent index build when I > have small files. I would guess you would see similar performance with the > resize. But it is a guess on my part. It will be interesting to see if > anybody has used it. > > -----Original Message----- > From: u2-users-boun...@listserver.u2ug.org [mailto: > u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeffrey Butera > Sent: Tuesday, March 05, 2013 2:43 PM > To: U2 Users List > Subject: [U2] Unidata RESIZE CONCURRENT > > So is anyone using Unidata's RESIZE CONCURRENT in production > environments? I have a dedicated maintenance window, so performing > regular file resizing usually isn't a problem here but I'm considering > moving over to using the CONCURRENT feature - particularly if a fire > crops up in our production environment. > > Just curious about people's experience with it and the possible impact > on performance in a production environment. > > -- > Jeffrey Butera, PhD > Associate Director for Applications and Web Services > Information Technology > Hampshire College > 413-559-5556 > > http://www.hampshire.edu > http://www.facebook.com/hampshirecollegeit > > _______________________________________________ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > > > ------------------------------------------------------------------------------ > CONFIDENTIALITY NOTICE: If you have received this email in error, > please immediately notify the sender by e-mail at the address shown. > This email transmission may contain confidential information. This > information is intended only for the use of the individual(s) or entity to > whom it is intended even if addressed incorrectly. Please delete it from > your files if you are not the intended recipient. Thank you for your > compliance. Copyright (c) 2013 Cigna > > ============================================================================== > > _______________________________________________ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > -- John Thompson _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
