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/
