1. Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING) Click the link to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This message will disappear after you have made at least 12 posts. Thank you for your cooperation.

Large file on TSM

Discussion in 'Scripting' started by dhipp, Jun 27, 2012.

  1. dhipp

    dhipp New Member

    Joined:
    Feb 2, 2011
    Messages:
    14
    Likes Received:
    0
    Can someone show me a SQL statement to show the ll_name that is greater than 200GB in size?
     
  2.  
  3. Trident

    Trident Senior Member

    Joined:
    Apr 2, 2007
    Messages:
    277
    Likes Received:
    25
    Occupation:
    IT operations
    Location:
    Oslo, Norway
    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: Jun 27, 2012

Share This Page