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:[EMAIL PROTECTED] Behalf Of PAC Brion Arnaud Sent: Tuesday, May 04, 2004 8:43 AM To: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] *********************************************************************** -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Hart, Charles Sent: Tuesday, 04 May, 2004 15:19 To: [EMAIL PROTECTED] 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:[EMAIL PROTECTED] Behalf Of Lawrence Clark Sent: Tuesday, May 04, 2004 8:12 AM To: [EMAIL PROTECTED] 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? >>> [EMAIL PROTECTED] 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 <[EMAIL PROTECTED] alpina.com> To Sent by: "ADSM: [EMAIL PROTECTED] 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: [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 ********************************************************************** 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. **********************************************************************
