ADSM-L

Minimizing Database Utilization

2002-07-30 10:19:30
Subject: Minimizing Database Utilization
From: Todd Lundstedt <Todd_Lundstedt AT VIA-CHRISTI DOT ORG>
Date: Tue, 30 Jul 2002 09:17:40 -0500
TSM 4.2.1.7 running on AIX 4.3.3
Database is 8GB, 66.2% utilized.  DBVols are on an ESS shark.

We have an application server that the admins would like to backup on the
TSM server.  The problem is, after I analyzed the backup needs of this one
server, my database would grow an additional 300GB, and increase in size an
additional 50-100MB each day (in actuality, it may be an additional 66%
growth because I can't recall if I calculated my copy storage pool needs).
They have a folder on this server (NT4.0 running a PACS system, by Fujimed,
I think) that contain over 240K+ files, each file in it's own folder (so
240K+ folders) each uniquely named, never changing, and almost all of the
files less than 1K in data size.  There are other similar folders on this
server that would significantly increase the size of the database, but not
as much as this one folder.  I based the increase in DB size on the "600k
of database space per object stored by TSM" rule.  I told the admin there
would be no way I could back that data up unless he created a zip file (or
something similar) of all those directories/files first.  He is looking
into this possibility.
Is there any other way to do this without increasing the size of my
database more than the size of the files being backed up (what is that... 3
million times more?)?

Thanks in advance for your help.

Todd Lundstedt
Technical Specialist
Via Christi Information Management Services
Todd_Lundstedt AT via-christi DOT org
<Prev in Thread] Current Thread [Next in Thread>