Frequent submitter, and all-around great guy, Mark Stapleton helped with this. (though he DOES still owe me a mug!)
We do this from within an AIX Korn-shell script. This is basics of the logic: ----------------------------------- # get a list of copypool tapes that are NOT offsite dsmadmc -id admin -pass=$TSMPWD "select volume_name from volumes where stgpool_name-='COPYPOOL' and access <>'OFFSITE' "| sed '1,2d | grep -c "^ *$" | grep -v AND[0-9] > $CHECKOUTLIST # get a list of the DBB tapes dsmadmc -id=admin -pass=$TSMPWD "select volume_name from volhistory where type='BACKUPFULL'" | sed '1,2d' | grep -v "^ *$" | grep -v ANS[0-9] > $TMPDBLIST # compare the backup tapes to that currently known to be offsite # to find the onsite DBB cat $PHYSICALVAULTLIST | while read VOL_LABEL; do VAL=$VAL$VOL_LABEL\| done VAL=$VAL"garbage" egrep -v $VAL $TMPDBLIST >> $CHECKOUTLIST # change the status of the ones to be checked out and ccheck 'em out cat $CHECKOUTLIST | while read VOL_LABEL; do dsmadmc -id=admin -pass=$TSMPWD "upd vol $VOL_LABEL access=offsite" > $CHECKOUTLOG 2> &1 dsmadmc -id=admin -pass=$TSMPWD "checkout libv <your lib> $VOL_LABEL checklabel=no remove=bulk" >> $CHECKOUTLOG 2>&1 done -------------------------------- -----Original Message----- From: Etienne Brodeur [mailto:[EMAIL PROTECTED]] Sent: Monday, December 10, 2001 2:40 PM To: [EMAIL PROTECTED] Subject: Re: Script to CHECKOUT multiples tapes on SCSI library But If I do what you suggest it would also checkout the tapes for my onsite copies that are full right? I am looking for a way to check out multiples tapes with one command (running a script would be my guess) to take a list of predetermined tapes out of a LTO 3583. I want to be able to check out the OFFSITE tapes that are full and filling and the daily DB backup that is in the OFF devclass. Is ther a script that will allow me to identify them and then create a macro file that could be run from to check them out one by one with REMOVE=BULK?\ If anyone has this would you mind sharing? Thanks for your help, Etienne Brodeur Martin Trcka <mtrcka@SMPAS To: [EMAIL PROTECTED] .CZ> cc: Sent by: Subject: Re: Script to CHECKOUT multiples tapes on SCSI library "ADSM: Dist Stor Manager" <[EMAIL PROTECTED] RIST.EDU> 2001-12-10 08:07 AM Please respond to "ADSM: Dist Stor Manager" > Is the MOVE MEDIA a command I could use to do this? Yes. Issue "MOVE MEDIA * STG=* wherestatus=full", f.e. This will check all full tapes from your library out. Martin Trcka ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com **********************************************************************