Kevin, Keep in mind, you still need a "quiet" database or you'll have numerous file access or corruption issues if processes try to access the file(s) while you reseize. Also, you need to be sure to monitor temp space or multiple resizes can fill it up and fail. Dynamics use the local space, so you need to treat those differently. I looked at FAST, but due to several limitations, it was not going to work in our environment. I created my own program, using guide -r for recommendations, that only resizes static files 200meg and under, checks temp space before and after(using the new sizing numbers), redirects the resizes to an area with enough free space. Dynamics and large files are done manually. I also stop and start Unidata, locking out all access to the accounts, rerun guide when I am done to check for corruption, and only resize files in overflow, never downsizing a file automatically. There is alot to think about and I'd look long and hard at tools like FAST before using them as a cure all, may be a good tool, but I'd be prepared for alot of monitoring and manual intervention. Good luck!
"Kevin King" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 11/24/2004 10:01 AM Please respond to u2-users To: <[EMAIL PROTECTED]> cc: Subject: RE: [U2] Resizing All Files in a System Can we then assume that you're not interested in a packaged solution like FAST? -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, November 24, 2004 7:17 AM To: [EMAIL PROTECTED] Subject: [U2] Resizing All Files in a System Is there a way to semi-automagically resize all the files in a UniData account/system? When we used Pick D3, we could run a process which would store the mod to use on restore in the file definition item. If we did a full system file save and restore, the files would be recreated with the "new and improved" mod. We use to do this on a fairly regular basis, but since changing to UniData, we haven't really addressed this. I know I can use guide to get suggested resizing, and that I can use memresize to actually resize an individual file, but is there a way to do this system wide? We are considering migrating to a newer machine, and since we would have a system with no users on it for a while, it seems to be the best time to implement a massive update. Pointers to the correct manual would be appreciated, or a brief summary. I'm certain that this has been discussed before, but I couldn't find it in the archives. --Tom Pellitieri Century Equipment Toledo, Ohio ------- 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/ ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/