ADSM-L

Re: [ADSM-L] Details of large file backed up via TSM

2009-05-25 00:42:14
Subject: Re: [ADSM-L] Details of large file backed up via TSM
From: Paul Dudley <pdudley AT ANL.COM DOT AU>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Mon, 25 May 2009 14:40:05 +1000
I am aware of the potential problem you raise below which is why I
scheduled it to start running at 6 am on Saturday morning as activity on
the TSM server during the day on Saturday is minimal.

I discovered this large file from the output of the "q pr" command. The
file was either being moved as part of a migration or reclaimation
process. I have seen it appear on a number of occasions over the past
few months in these processes.

Thanks & Regards
Paul

Paul Dudley
Senior IT Systems Administrator
ANL Container Line Pty Limited
Email: pdudley AT anl.com DOT au
Web: http://www.anl.com.au



-----Original Message-----


The greater issue: Performing a Select against the Contents table is
basically suicidal: it's the worst table to query, where a query could
run for days and cripple your TSM server.  I would instead recommend
inspecting the accounting log for a session with data of that size,
and 1 or few objects.  Likewise you could scan the ANE messages in the
Activity Log, or have a look at the Summary table, for recent
sessions.  You don't say how you know about that file having been
backed up: that may lead to more concise ways to determine its origin.

    Richard Sims






ANL DISCLAIMER

This e-mail and any file attached is confidential, and intended solely to the 
named addressees. Any unauthorised dissemination or use is strictly prohibited. 
If you received this e-mail in error, please immediately notify the sender by 
return e-mail from your system. Please do not copy, use or make reference to it 
for any purpose, or disclose its contents to any person.