Gary, I understand your frustration at starting out, but the SQL command for this request is not difficult and has been answered on this list a number of times. It is difficult to pull that information out with all the activity and matches that you get, however, so feel free to ask such questions here.
One format of the command you need is: select volume_name, stgpool_name, filespace_name from volumeusage where node_name='NODENAME' where NODENAME is the name of the node in question in all caps. That will show you which primary and copy pool tapes you need for the restore. To just see the tapes for a specific storage pool for you case, add a selection of the storage pool name: select volume_name, stgpool_name, filespace_name from volumeusage where node_name='NODENAME' where stgpool_name='TAPEPOOL' where TAPEPOOL is the name of your primary tape pool. As you already know, this is not necessary if you have enough robot slots to hold all your primary tapepool tapes. Proper sizing of a TSM environment before purchase is quite important. Bill Smoldt STORServer -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Gary Swanton Sent: Wednesday, February 13, 2002 2:02 AM To: [EMAIL PROTECTED] Subject: RESTORE VOLUMES Hi All, I am quite new to all things TSM and I have a question to what I believe is an unrealistic situation. Presently if, during my role as the TSM administrator I am asked to perform a data restore, I have no idea of what volumes will be required for the data. I have a 30 slot library at my disposal, which I appreciate is quite small, however, if after I kick off a restore I should have some indication as to what volumes are required thereby allowing me to check the volumes into the library before the restore job commences. A recent example: I had to restore 80MB worth of data and it took over 3.5 hours and over 18 tape changes. The present situation is that after I start a restore I have to be glued to the console and wait for tape requests to appear in the activity log or via a pop-up. My research has shown that other people have been asking the same thing as far back as 1998 but no-one appears to have provided a solution. Tivoli have told me that it is possible with some pretty complex SQL statements. Great now I have to learn SQL queries as well. Does anybody have any ideas on this matter? It's not that hard surely..Oh yeah I'm running TSM Server 4.2.10 on a W2K platform with current clients running 4.2.1. Gary Swanton Microsoft Certified Systems Engineer [EMAIL PROTECTED]
