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: pdud...@anl.com.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.
