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