Large file on TSM

**dhipp** · 06-27-2012, 10:48 AM

Can someone show me a SQL statement to show the ll_name that is greater than 200GB in size?

**Trident** · 06-27-2012, 02:56 PM

Hi,

This query IS NOT RECOMMENDED. It may take a long time if your TSM DB is large, or running on slow disks. You have been warned.

Code:

select * from contents where FILE_SIZE>200000000000

A better approach will be to determine what node has more than 200Gb from the auditocc table, and start from there.

Code:

select * from auditocc where total_mb>200000

Then run

Code:

select * from contents where FILE_SIZE>200000000000 and NODE_NAME='Your_Node_Name'

Thread: Large file on TSM