Is there anyway of telling which tapes a restore is going to use in advance, before we actually submit it ? Currently, restores are throwing up requests for any tapes that are not in the medialib; it waits an hour then skips the file and continues. (We need to keep some ONSITE tapes externally to the medialib due to space constraints).
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Restores
- Thread starter maxcrook
- Start date
Not an easy task.
Some ideas:
you can first look for the order of restore with dsmc q backup <file system>
After that you can check volumes with
something like
q content <volume> -nodename= ...
Or may be you can write a program with API
to do this.
Or you can set flag -mountwait=no on restore,
after that check output, which files has been skipped an check where they are.
Just some ideas, I am sure there are more
possibilities to do this.
Some ideas:
you can first look for the order of restore with dsmc q backup <file system>
After that you can check volumes with
something like
q content <volume> -nodename= ...
Or may be you can write a program with API
to do this.
Or you can set flag -mountwait=no on restore,
after that check output, which files has been skipped an check where they are.
Just some ideas, I am sure there are more
possibilities to do this.
amphibient
Programmer
If you want to see what tapes a node uses that are not checked in, (not in the libvolumes table) for a restore:
SELECT distinct(volume_name) FROM volumeusage WHERE volume_name NOT IN (SELECT volume_name from libvolumes) AND node_name='NAME_OF_THE_NODE_IN_QUESTION'
otherwise, to get a list of all tapes that a node has data on:
SELECT distinct(volume_name) FROM volumeusage WHERE node_name='NAME_OF_THE_NODE_IN_QUESTION'
this works on 5.1.5/9 and 5.2 TSM servers.
if you have multiple libraries, you might wanna change it a little bit..
SELECT distinct(volume_name) FROM volumeusage WHERE volume_name NOT IN (SELECT volume_name from libvolumes) AND node_name='NAME_OF_THE_NODE_IN_QUESTION'
otherwise, to get a list of all tapes that a node has data on:
SELECT distinct(volume_name) FROM volumeusage WHERE node_name='NAME_OF_THE_NODE_IN_QUESTION'
this works on 5.1.5/9 and 5.2 TSM servers.
if you have multiple libraries, you might wanna change it a little bit..
- Status