ADSM-L

Re: Minimizing Database Utilization

2002-08-02 16:10:29
Subject: Re: Minimizing Database Utilization
From: Don France <DFrance-TSM AT ATT DOT NET>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Tue, 30 Jul 2002 22:35:47 -0700
Actually, you need to consider (a) 600 bytes per primary pool object, plus
(b) 200 bytes per copypool object... pretty simple, and "it works"!

Don France
Technical Architect -- Tivoli Certified Consultant
Tivoli Storage Manager, WinNT/2K, AIX/Unix, OS/390
San Jose, Ca
(408) 257-3037
mailto:don_france AT att DOT net

Professional Association of Contract Employees
(P.A.C.E. -- www.pacepros.com)



-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
Todd Lundstedt
Sent: Tuesday, July 30, 2002 8:42 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Minimizing Database Utilization


Well, well.. I totally read my book the wrong way.  I will go recalculate.
Thanks for pointing out this huge error on my part.  Now I have to go
figure out where the rest of my database utilization is going, too.


|--------+---------------------------->
|        |          "Thomas Denier"   |
|        |          <Thomas.Denier@mai|
|        |          l.tju.edu>        |
|        |                            |
|        |          07/30/02 10:37 AM |
|        |                            |
|--------+---------------------------->

>---------------------------------------------------------------------------
-----------------------------------------|
  |
|
  |      To:     ADSM-L AT VM.MARIST DOT EDU, Todd_Lundstedt AT VIA-CHRISTI DOT 
ORG
|
  |      cc:
|
  |      Subject:     Re: Minimizing Database Utilization
|

>---------------------------------------------------------------------------
-----------------------------------------|




> I based the increase in DB size on the "600k
> of database space per object stored by TSM" rule.

I believe the rule of thumb historically given in TSM documentation
is 600 bytes per object, not 600 kilobytes. I have a single client
with 4.8 million backup files in one of its file systems, and several
others with substantial fractions of that number. I have offsite copy
pools for all backups. All of this fits in a ten gigabyte database.

<Prev in Thread] Current Thread [Next in Thread>