ADSM-L

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>