We will let our masters reach close to 80% full and resize them to 60% when we
have to touch them.

Since we have a window of data base maintenance once a month, we also trend them
(mentally, not in any kind of automated way) and when a master is approaching
80% or  is likely to be there by the monthly cycle after the current one, we'll
resize it.

===================
Leonard S. Berkowitz
Perot Health Care Systems
(Harvard Pilgrim Health Care account)
voice: 617-509-1212
fax:   617-509-3737
pager: 781-226-2431







Larry Barnes <[log in to unmask]> on 07/20/2001 11:11:31 AM

Please respond to Larry Barnes <[log in to unmask]>



  To:          [log in to unmask]

  cc:          (bcc: Leonard Berkowitz/CORP/HPHC)



  Subject      [HP3000-L] DB Capacity Formual
  :







As I monitor our DB's I have to increase Master/Automatic data sets on
occassion to maintain a certain percentage of free space in these data sets.
Is there any formula to determine the new size of a data set when adding 'X'
number of records to it?

I've searched the archives and haven't found anything yet.

Larry A. Barnes
Systems Administrator - HP3000
Coldwater Creek Inc.

Fax:   208 265-3203

http://www.coldwatercreek.com

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *