What I was really trying to calculate was what would the new sector size be
when I increase an individual, based on current values.

Patrick from Adager was able to help me offline.

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

Fax:   208 265-3203

http://www.coldwatercreek.com




-----Original Message-----
From: Chris Goodey [mailto:[log in to unmask]]
Sent: Friday, July 20, 2001 11:43 AM
To: Larry Barnes
Subject: RE: [HP3000-L] DB Capacity Formual


Is totally dependent on the nature of your data.

One application might add exactly one master and one detail record at a
time.

Another application (like Ecometry) might add one master, and a number of
details
per master depending on how big the order.

-----Original Message-----
From: Larry Barnes [mailto:[log in to unmask]]
Sent: Friday, July 20, 2001 8:12 AM
To: [log in to unmask]
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 *