Hi Arnaud,
You can also take a look at the SUMMARY table, which contains a lot of the
same information that appears in the account log. Something like this
might prove to be a useful starting point:
select entity as NODE,
date(end_time) as DATE,
activity,
sum(examined) as EXAMINED,
sum(affected) as OBJECTS,
sum(bytes) as BYTES
from summary
where activity='BACKUP' or activity='ARCHIVE'
group by entity, end_time, activity
Look for increases to number of OBJECTS over time, new node names, etc.
Regards,
Andy
Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED]
Internet e-mail: [EMAIL PROTECTED]
The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.
PAC Brion Arnaud <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
05/04/2004 08:05
Please respond to
"ADSM: Dist Stor Manager"
To
[EMAIL PROTECTED]
cc
Subject
Re: TSM DB growing, but number of files remains the same ...
Mark : thanks for the tip, I'll give it a try !
Ted : as per TSM help : The environment variable,
DSMSERV_ACCOUNTING_DIR, specifies the directory where the accounting
file is located. Now I know this, but as said before, forgot to
reactivate accounting ...
Arnaud
***********************************************************************
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
Stapleton, Mark
Sent: Tuesday, 04 May, 2004 16:59
To: [EMAIL PROTECTED]
Subject: Re: TSM DB growing, but number of files remains the same ...
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Ted Byrne
>You could always make the accounting log file a softlink to a more
>forgiving location...
>
>It probably would also make sense to do some kind of regular log
rotation
>with the file.
Once a month, run
cd /usr/tivoli/tsm/server/bin
compress dsmaccnt.log
mv dsmaccnt.log.Z <filesystem_with_more_space>/dsmaccnt.log.Z.`date
+%Y%M`
This will give you compressed accounting files by year and month.
--
Mark Stapleton
