Results 1 to 2 of 2
Thread: Large file on TSM
06-27-2012, 10:48 AM #1
- Join Date
- Feb 2011
- Thanked 0 Times in 0 Posts
Large file on TSM
Can someone show me a SQL statement to show the ll_name that is greater than 200GB in size?
06-27-2012, 02:56 PM #2
- Join Date
- Apr 2007
- Oslo, Norway
- Thanked 19 Times in 19 Posts
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
select * from auditocc where total_mb>200000
select * from contents where FILE_SIZE>200000000000 and NODE_NAME='Your_Node_Name'
Last edited by Trident; 06-27-2012 at 02:57 PM. Reason: typo-= Trident =-
By matze in forum TSM OperationReplies: 2Last Post: 09-30-2011, 02:55 PM
By karim in forum Capacity PlanningReplies: 2Last Post: 03-18-2010, 09:32 AM
By TeEsEm in forum Backup / Archive DiscussionReplies: 1Last Post: 11-29-2006, 06:01 PM
By vjy5959 in forum Hierarchical Storage ManagementReplies: 1Last Post: 05-26-2005, 05:49 PM
By schulerta in forum Backup / Archive DiscussionReplies: 2Last Post: 02-02-2004, 04:46 AM