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: [EMAIL PROTECTED] *********************************************************************** -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Richard Sims Sent: Tuesday, 04 May, 2004 13:08 To: [EMAIL PROTECTED] 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
