Results 1 to 2 of 2
  1. #1
    Newcomer
    Join Date
    Feb 2011
    Posts
    14
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default Large file on TSM

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

  2. #2
    Senior Member Trident's Avatar
    Join Date
    Apr 2007
    Location
    Oslo, Norway
    Posts
    269
    Thanks
    2
    Thanked 19 Times in 19 Posts

    Default

    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'
    Last edited by Trident; 06-27-2012 at 02:57 PM. Reason: typo
    -= Trident =-

Similar Threads

  1. Backup-Problem of a large File
    By matze in forum TSM Operation
    Replies: 2
    Last Post: 09-30-2011, 02:55 PM
  2. Large file support (>1TB)?
    By karim in forum Capacity Planning
    Replies: 2
    Last Post: 03-18-2010, 09:32 AM
  3. dsmsched.log file very large
    By TeEsEm in forum Backup / Archive Discussion
    Replies: 1
    Last Post: 11-29-2006, 06:01 PM
  4. Is it possible to migrate large file using HSM with spliting file.
    By vjy5959 in forum Hierarchical Storage Management
    Replies: 1
    Last Post: 05-26-2005, 05:49 PM
  5. TSM and Large Netware File shares
    By schulerta in forum Backup / Archive Discussion
    Replies: 2
    Last Post: 02-02-2004, 04:46 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •