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";

chris.pasztor AT mantrack DOT com





Muthukumar Kannaiyan <mkannaiyan AT WORLDBANK DOT ORG> on 15/02/2006 03:20:12

Please respond to "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>



To:   ADSM-L AT VM.MARIST DOT 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