We upgraded from 4.1.c to 5.1 and did not go through the 4.2 Release with that 
bug, but ran it anyway and it cleaned  up Millions and Millions of SysObj...  
Worth a try.  Once you start the process you can watch it to see if it does 
delete obj...



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


John : nope, I hoped to find another way doing it, something easier, but
I'll be olbliged to follow your advice !
Lawrence : I thought to that one too, but it's not the case ...
Charles : As we're actually running a 5.2 version, this should not be a
problem : even when we where with 4.2, I never faced this bug.
Thanks anyway for your input !

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
Hart, Charles
Sent: Tuesday, 04 May, 2004 15:19
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: TSM DB growing, but number of files remains the same ...


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.
**********************************************************************