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.

Query tape for restore

Discussion in 'Restore / Recovery Discussion' started by dineshgoundar, Mar 24, 2011.

Thread Status:
Not open for further replies.
  1. dineshgoundar

    dineshgoundar New Member

    Joined:
    Mar 20, 2011
    Messages:
    4
    Likes Received:
    0
    Occupation:
    Disaster Recovery Specialist
    Location:
    New Zealand
    Hi Guys,

    I have got to recover four servers. My TSM server is ready. How can I query the DB to find the tapes that I require to recover individual servers? I am recovering from Offsite Copy Pool. This is a DR test situation.

    This is a windows environment with TSM 5.5

    I have used this command: query nodedata <node_name> but this gives me a list of tapes out of which 50% are not in the Offsite Pool.

    I remember seeing another query in this forum with something like "select xxx,xxx..." few days a ago and cant find that now.

    * Note: I am new to TSM so detailed info would be appreciated.

    Thanks
    DG
     
  2.  
  3. cjhood

    cjhood Moderator

    Joined:
    Dec 11, 2007
    Messages:
    322
    Likes Received:
    10
    Occupation:
    Storage Administrator - TSM/SAN
    Location:
    Brisbane, Australia
    Try this:

    select volume_name from volumeusage where node_name='NODENAME' and stgpool_name='OFFSITEPOOLNAME'
     
  4. dineshgoundar

    dineshgoundar New Member

    Joined:
    Mar 20, 2011
    Messages:
    4
    Likes Received:
    0
    Occupation:
    Disaster Recovery Specialist
    Location:
    New Zealand
    Thanks Chris,

    It worked perfectly. Servers are restoring now. Thanks alot.

    Much appreaciated
     
Thread Status:
Not open for further replies.

Share This Page