dbTalk Databases Forums  

Favorite Way to Resize?

comp.databases.pick comp.databases.pick


Discuss Favorite Way to Resize? in the comp.databases.pick forum.



Reply
 
Thread Tools Display Modes
  #11  
Old   
Frank Winans
 
Posts: n/a

Default Re: Favorite Way to Resize? - 08-02-2006 , 02:46 PM







"ddspell-m3" wrote
Quote:
Is there a rename-account TCL command?
ACCOUNT-MAINT HARRY

on d3 puts you into an edit session on a little
paragraph of name and module and other specs
about the HARRY account.

There you can edit the name and issue the FI
command to file the results to hard disk.


The d3 command STEAL-FILE is for moving
ownership of a file to another account.




Reply With Quote
  #12  
Old   
digitalhandyman
 
Posts: n/a

Default Re: Favorite Way to Resize? - 08-07-2006 , 02:46 PM






When setting up new and supporting existing clients I configure the
"file-sizer" utility which can resize items automatically on a schedule
that you setup. I usually set it to resize an item to 74% full once a
week on sunday evening as alot of our customs will perform large
imports of data from other systems. There's no real need to do a
complete save and restore with d3 on a windows system just to
resize(well I would say on recent versions of d3, somewhere after 7.2 ).





On 2006-07-31 06:04:19 +0300, "Frank Winans" <fwinans (AT) sbcglobal (DOT) net> said:

Quote:
"ddspell-m3" wrote
What is your favorite way to resize and how often do you do it?
Is the F-RESIZE, FILE-SAVE, then restore the *best* way?
If it is, it seems a bit impractical to take a 24/7 production system
offline for 3 to 4 hours, plus I'd rather not give up every weekend to
do this chore.
Weekly monitoring maybe, but actual resizing shouldn't need to
happen more than twice a year, or you're not oversizing big enough.

You could manually save/restore just one account, or
save/delete/create/restore a handfull of large files, as sort of a
stop-gap
measure if you can't budget enough down-time to do a full save/restore
-- if your overflow {alias "FREE"} space isn't too fragmented already.
This goes nicely with using big disk files instead of tapes to do the backup,
as there's not that worry about 2gig or 4gig filesize limits on
certain platforms
if you're just doing a partial backup for resizing; real tapes are sooo slow.



Reply With Quote
  #13  
Old   
Frank Winans
 
Posts: n/a

Default Re: Favorite Way to Resize? - 08-07-2006 , 08:08 PM




"digitalhandyman" wrote
Quote:
When setting up new and supporting existing clients I configure the
"file-sizer" utility which can resize items automatically on a schedule
that you setup. I usually set it to resize an item to 74% full once a
week on sunday evening as alot of our customs will perform large
imports of data from other systems. There's no real need to do a
complete save and restore with d3 on a windows system just to
resize(well I would say on recent versions of d3, somewhere after 7.2 ).

Things seem to have advanced nicely since the old f-resize, which
a) relied on file sizes in fof from a save with (s flag and
b) merely noted what the new size would be after next save/restore.
And it could have really benefitted from an EQUate listing the % full
target ratio in the source code -- lotsa people want to tweak that figure...




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.