Great to see you back, Richard. Not to quibble with the guru, but -- a: how do you know the volume name? b: query content? Won't that take a long time and maybe adversely impact the TSM server's performance?
--------------------------------- Mr. Lindsay Morris Lead Architect, Servergraph www.servergraph.com <http://www.servergraph.com> 859-253-8000 ofc 425-988-8478 fax > -----Original Message----- > From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of > Richard Sims > Sent: Friday, December 06, 2002 9:22 AM > To: [EMAIL PROTECTED] > Subject: Re: Ned a SQL QUERY - Where did my big files come from? > > > >I have some big files (10+G and one 31+Gig file) that is being backed up. > >Is there a query that I can use to find what the big files are and what > >client they belong to? > > The TSM administrator sometimes has to determine what files a current or > recent backup has sent. The simplest way is, knowing the volume they went > to: > > query content Volname count=-20 format=detailed > > for example, where some reasonable negative number will show you > the latest > files on the volume, listed most recent first. This is easiest with large > backup files, like yours, where they will very likely show up > within a limited > count value. > > Richard Sims, BU >