Results 1 to 3 of 3
  1. #1
    Newcomer
    Join Date
    Mar 2011
    Location
    New Zealand
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Smile Query tape for restore

    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. #2
    Moderator
    Join Date
    Dec 2007
    Location
    Brisbane, Australia
    Posts
    322
    Thanks
    0
    Thanked 1 Time in 1 Post

    Default

    Try this:

    select volume_name from volumeusage where node_name='NODENAME' and stgpool_name='OFFSITEPOOLNAME'
    -Chris

  3. #3
    Newcomer
    Join Date
    Mar 2011
    Location
    New Zealand
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    Thanks Chris,

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

    Much appreaciated

Similar Threads

  1. Tape Query
    By treds in forum Scripting
    Replies: 11
    Last Post: 08-26-2009, 01:12 PM
  2. TSM Restore Query
    By FBIV in forum Restore / Recovery Discussion
    Replies: 0
    Last Post: 04-03-2009, 02:21 PM
  3. query tape in tape drive
    By jcabrera in forum Tape / Media Library
    Replies: 3
    Last Post: 04-23-2007, 10:01 AM
  4. No Query Restore Problems
    By bot403 in forum Restore / Recovery Discussion
    Replies: 2
    Last Post: 07-11-2006, 06:04 PM
  5. Restore to Different location query
    By Tonyc123 in forum Restore / Recovery Discussion
    Replies: 1
    Last Post: 07-04-2006, 03:46 AM

Tags for this Thread

Posting Permissions

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