I use a SQL query to match the tape number from volhist and the backupset names in backupsets like
SELECT VOLHISTORY.VOLUME_NAME,BACKUPSETS.BACKUPSET_NAME,BACKUPSETS.DATE_TIME,BACKUPSETS.DESCRIPTION FROM VOLHISTORY,BACKUPSETS WHERE VOLHISTORY.TYPE='BACKUPSET' AND VOLHISTORY.DATE_TIME=BACKUPSETS.DATE_TIME"; [EMAIL PROTECTED] Muthukumar Kannaiyan <[EMAIL PROTECTED]> on 15/02/2006 03:20:12 Please respond to "ADSM: Dist Stor Manager" <[email protected]> To: [email protected] cc: (bcc: Chris Pasztor/HCS) Subject: [ADSM-L] Backupset question I am trying create backupset from TSM for few nodes. Where do I keep track of tape serial number for corresponding node's backup ? Following command I am using generat backupset node1 node1 * devc=3494dc scr=yes ret=60 Regards Muthu 202-458-8340 - Work
