Database calculations
1994-08-05 10:27:57
Subject: |
Database calculations |
From: |
Ron Ritchey <[email protected]> |
Date: |
Fri, 5 Aug 1994 09:27:57 CDT |
Can someone explain how ADSM's data base works. Specifically how it
partitions the data base for indexes and physical files. Does it
migrate the physical files out of the database so the indexes can grow?
Will the index grow until the database is completely full or just until
it is a % full? Is the formula for figuring the database index space
linear? We need to keep seven full backups of a 2Gb server. For
testing purposes we have a 87Mb database. The database filled up after
66% of the second backup. I queried the database. It said it was
97.6% utilized.
By the formulas in the book, I figured that it was going to take 1225
cylinders.
For example 2Gb X 7copies = 14Gb
14Gb X .05% of database = .7
.7 X 1000 = 700Mb
700Mb X 1.75 = 1225 Cylinders
This is only one of several servers we want to backup, not including
all of our workstations. We can't dedicate that much DASD to ADSM.
Are my figures correct? Does anyone have any input that could help
me?
Thanks for your response in advance...
+----------------------------------------------------------------------+
| Ronald W. Ritchey Systems Programmer/Analyst |
| University of Nebraska Internet: OSG0312 AT unlvm.unl DOT edu |
| 235 Nebraska Hall BITNET: OSG0312@unlvm |
| Lincoln NE, 68588-0521 Phone: (402)472-7605 |
+----------------------------------------------------------------------+
|
<Prev in Thread] |
Current Thread |
[Next in Thread>
|
- Database calculations,
Ron Ritchey <=
|
|
|