Depending on the server version (4.2.x) there was an issue where Win2k System 
objects were not expiring based on the retention policies.  Try and run 
"cleanup backupgroups" Keep an eye as it can run the log up rather quickly.  
Once this process completed for us we saw or 120GB DB go from 80% to 60%....

Regards,

Charles




-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
Lawrence Clark
Sent: Tuesday, May 04, 2004 8:12 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: TSM DB growing, but number of files remains the same ...


has someone increased the number of days that activity is retained in
the db?

>>> John.Naylor AT SCOTTISH-SOUTHERN.CO DOT UK 05/04/2004 9:04:27 AM >>>
Arnaud,
Have you queried the activity log over the last week As your database
is
increasing so raoidly the client session stats
should show clients with large numbers of objects backed up




             PAC Brion Arnaud
             <Arnaud.Brion@pan
             alpina.com>
To
             Sent by: "ADSM:           ADSM-L AT vm.marist DOT edu
             Dist Stor
cc
             Manager"
             <[email protected]
Subject
             .edu>                     Re: TSM DB growing, but number
of
                                       files remains the same ...

             04/05/2004 13:20


             Please respond to
             "ADSM: Dist Stor
                 Manager"
             <[email protected]
                   .edu>






Richard,

As a "relatively" experienced ADSM/TSM user, I entirely agree with
what
you said, but, as told in my mail, I doubt that any of my client has
begun sending more files than usually, because following query "select
sum(num_files) from occupancy" returns a relatively constant value.
From
my perception, if I suddenly had more versions of the same files, this
field should increase, or I am wrong and it does only count 1 unit for
each filename, without considering the number of versions TSM keeps in
its DB ? (5 versions of the same file will be counted as 1 ?)

Arnaud Brion

***********************************************************************
Panalpina Management Ltd., Basle, Switzerland, CIT Department
Viadukstrasse 42, P.O. Box 4002 Basel/CH
Phone:  +41 (61) 226 11 11, FAX: +41 (61) 226 17 01
Direct: +41 (61) 226 19 78
e-mail: arnaud.brion AT panalpina DOT com
***********************************************************************




-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf
Of
Richard Sims
Sent: Tuesday, 04 May, 2004 13:08
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: TSM DB growing, but number of files remains the same ...


>I'm facing a strange problem, in that my DB began to grow at an
>abnormal rate, a couple of weeks ago. I tried to find out the reason
>why ...

As we keep advising List members:  Run regular TSM accounting reports
and review the results, both for quick detection of "runaway" clients
and for long term capacity planning.  This will allow you to know for
certain where all the new TSM database objects/activity are coming
from,
and when.

You may find that, though a client's file system population remains
largely the same, the number of versions it may be generating may
suddenly balloon, due to a new company project or the like: each
database entry may effectively inflate with increased instances of the
same object - plus backup stgppool recording.

   Richard Sims    http://people.bu.edu/rbs




**********************************************************************
The information in this E-Mail is confidential and may be legally
privileged. It may not represent the views of Scottish and Southern
Energy Group.
It is intended solely for the addressees. Access to this E-Mail by
anyone else is unauthorised. If you are not the intended recipient,
any disclosure, copying, distribution or any action taken or omitted
to be taken in reliance on it, is prohibited and may be unlawful.
Any unauthorised recipient should advise the sender immediately of
the error in transmission.

Scottish Hydro-Electric, Southern Electric, SWALEC and S+S
are trading names of the Scottish and Southern Energy Group.
**********************************************************************