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.

Data stored per Management class

Discussion in 'TSM Operation' started by tonyg, Jul 20, 2012.

  1. tonyg

    tonyg New Member

    Joined:
    Jul 20, 2012
    Messages:
    1
    Likes Received:
    0
    Hi,

    I have been looking for a while for a way to view how much data is stored in a TSM server by Management class.

    And then maybe as the next step would be to list that per node.

    What I really am after is to work out how much data will be left over (stored) in the TSM server after a certain period of time - e.g 30 days, with no more backups occurring. So in other words, if no more backups occur and expiration runs for 30 days, how much data is left still in the tsm server after 30 days? The obvious way for me to get this is to know what storage is utilised by each mgmtclass, hence the original question. But if there is a another way to get what i am after, would be great to know.

    I have had no luck finding this answer, so any help would be greatly appreciated.

    Thanks
     
  2.  
  3. esiole

    esiole New Member

    Joined:
    Jan 24, 2006
    Messages:
    25
    Likes Received:
    1
    Occupation:
    IT Consultant
    Location:
    Mauritius
    Hello

    I know it is a bit old now, but could be still interesting.

    This is the one i'm using to do so and then perform some calculation based on the MGMT reported.

    Backup:
    select distinct FILESPACE_NAME, CLASS_NAME from backups where node_name='<nodename>'

    ARchive:
    select distinct FILESPACE_NAME, CLASS_NAME from archives where node_name='<nodename>'

    output is :
    FILESPACE_NAME CLASS_NAME
    ------------------ ------------------
    /db2/instance/db2dump ARCH_366
    /db2/instance/db2dump DB2_DBD_A_C_365
    /db2/instance/db2dump ARCH_30
     

Share This Page