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/IBM@IBMUS
Internet e-mail: storman AT us.ibm DOT com

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 <Arnaud.Brion AT PANALPINA DOT COM>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
05/04/2004 08:05
Please respond to
"ADSM: Dist Stor Manager"


To
ADSM-L AT VM.MARIST DOT EDU
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: arnaud.brion AT panalpina DOT com
***********************************************************************




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


From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] 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