Duane,

dsmadmc -id=id -password=password -comma -out=myfile select node_name, type,
filespace_name, num_files from occupancy

Once that's done, load myfile into your favorite spreadsheet or tab-data
massager (sometimes I use Perl).  You can start searching for
nodes/filespaces with very high numbers of files.  That's what'll cause DB
Bloat.  I think you can get the same information with just a "query
occupancy," but I've never used that output for something like this.

I hope this helps.

Alex Paschal
Freightliner, LLC
(503) 745-6850 phone/vmail

-----Original Message-----
From: Ochs, Duane [mailto:Duane.Ochs AT QG DOT COM]
Sent: Tuesday, April 22, 2003 8:11 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: DB growth.


Before this goes on I do appreciate the input. By default all system objects
are excluded.
I have already reviewed the obvious possibilities, but nothing really stands
out. Q auditoccupancy has been used, q occupancy and other commands to no
avail.

I was hoping someone had a query or a select statement that would help me to
look into the DB and see if there is something very obvious before I go
through client by client. All the TSM servers have the same MC definitions
and applied equally to all the servers and clients.


Duane