I can see that TSM has backed up a file that is 140 Gb in size. However
I have been unable to work out which server this file came from.
I want to query the TSM database to find out some information about that
file (its name, what server it was on, etc)
After some research it appears that the following command will query the
contents table in the database.
select FILE_NAME,FILE_SIZE from contents order by FILE_SIZE DESC
(DESC Specifies that the columns are sorted in descending order. -> you
see the biggest files at first)
I know that the file size is 142,499,909,632 bytes and it is probably
the largest file.
The TSM query I ran over the weekend was:
"select FILE_NAME,FILE_SIZE from contents where FILE_SIZE > 10000000000
order by FILE_SIZE DESC" > /tmp/file-list
The object of this command was to only list files greater than
10000000000 bytes in size.
The command ran and finished straight away so I knew it had not worked.
The output in file /tmp/file-list was:
Output of command redirected to file '10000000000'
ANS8001I Return code 3.
ANS8002I Highest return code was 3.
The output of file 10000000000 was:
ANS8000I Server command: 'select FILE_NAME,FILE_SIZE from contents where
FILE_SIZE'
ANR2909E The SQL statement is incomplete; additional tokens are
required.
Please note that it was not my intention to have output written to file
10000000000.
That number sets the lower limit of what file sizes I want to report on.
If anyone could let me know what the problem was with the query above it
would be appreciated.
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
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.
|
