Hello, > I'm looking for a query or sql script that allow me to see what volumes I'll > need for a restore process. I want to see the volumes before the starting of > the process. If your question is concerning nodes you can try to implement the following actions. We perform this by program in a product (SOS-Log that we sell only in France, sorry) so you'll have to adapt it in SQL (if possible or by script). Start with : select DISTINCT VOLUME_NAME NODE_NAME COPY_TYPE STGPOOL_NAME from VOLUMEUSAGE
crossing it with POOL_TYPE from STGPOOLS on STGPOOL_NAME sort by COPY_TYPE of VOLUMUSAGE (BACKUP, ARCHIVE) then sort the result by NODE_NAME Be careful, select on volumeusage is sometime very slow > Likewise I need a query or script that allow me to see what volumes I'll > need for a backup stgpool process. When I use preview=volumesonly or yes I > realize not always ask me the volumes that are in the list this command has > generated. Is there another way to do this? Maybe something like (again you'll have to adpat in good SQL syntax) : select volume_name from volumes where last_write_date > "your date time" and stgpool_name = "your stgpool" "your date time" is the TSM date time of the last copy Hope this helps If you read french, you can have a look at an example (somehow old) : http://www.sos-restore.com/demolog/log.htm Best regards Christian Bagard T�l :(33) 442 930 813 email : [EMAIL PROTECTED] SOS-Restore - 32 cours Mirabeau - 13100 Aix-en-Provence - France www.sos-restore.com (only french sorry)
