Large file on TSM

[dhipp]

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

 

[Trident]

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.

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.

select * from auditocc where total_mb>200000

Then run

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