How to Determine Information About a Huge File

[itdrew]

We have some large files in our environment, and I'd like to figure out what those files are, and which TSM clients they belong to.

Here is an example of what I am talking about. Keep in mind that there are thousands of small files on this same tape.

Backup Storage Pool

Primary Pool ON_DSK, Copy Pool OFF_TP,
Files Backed Up: 16,487, Bytes Backed Up:
334,334,435,328, Unreadable Files: 0, Unreadable
Bytes: 0. Current Physical File (bytes):
194,231,369,728 Current output volume(s):
891289L4.

In the above example, this backup stgpool process is moving a 194GB file from disk to tape. How can I determine what that file is, and where it came from?

I realize there are ways to configure large files to go directly to tape, but in this environment the disk pools are gigantic, and it isn't a bad idea having it go to disk first.

 

[marclant]

You could try this:

select * from contents where volume_name='891289L4' order by file_size desc fetch first 20 rows only

 

[itdrew]

Nice job marclant. That helped a lot. Thanks.