-----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Chris Pasztor Sent: Tuesday, February 14, 2006 12:27 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: Backupset question
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,BA CKUPSETS.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" <ADSM-L@VM.MARIST.EDU> To: ADSM-L@VM.MARIST.EDU 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