You might also be able to do this from the Web GUI. I remember a note from
last week where you could grab up a bunch of stuff and apply an action.
Are you sure your tapes were labeled in the first place, or are you certain
this is a drive problem? Both will cause this to happen.
I've found that by the time I figured out the select, dummied up a macro and
applied it, I could have issued update libvol commands and been done.
Granted I didn't learn anything except how bad I type, but I was done until
the next time.
Kelly J. Lipp
Storage Solutions Specialists, Inc.
PO Box 51313
Colorado Springs CO 80949-1313
(719) 531-5926
Fax: (240) 539-7175
Email: [EMAIL PROTECTED] or [EMAIL PROTECTED]
www.storsol.com
www.storserver.com
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of
Prather, Wanda
Sent: Wednesday, February 21, 2001 1:50 PM
To: [EMAIL PROTECTED]
Subject: Re: Scratch Tape Problem
Quick and dirty:
You can use an SQL select statement to build all the UPDATE statements you
need.
Change the SQL select statement below so that LIBRARYNAME is the name of
your library. It should be in upper case.
Then run the query and redirect the output into a file.
Edit the file to delete the header lines.
Then run the file as a macro by entering the command: macro filename
select 'udate libv libraryname', volume_name, ' status=scratch' from
libvolumes where status='Scratch' and library_name='LIBRARYNAME' >
c:\pathname\filename
-----Original Message-----
From: Wells, Alan [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 21, 2001 3:19 PM
To: [EMAIL PROTECTED]
Subject: Scratch Tape Problem
We have had some problems with a drive in our library.
After putting the tape online TSM began putting tapes in to write data.
The drive returned I/O errors and TSM responed by placing each tape in a
private status. We started receiving errors stating that there were not
enough
scratch tapes. After runing a q libvol I have discover that all tapes that
should
be in scratch (449 to be exact) are in private status.
Does anyone have a good idea on how I can get these 449 tapes back to a
scratch status.
I can run UPDATE LIBV LB10.0.0.7 CAA### STATUS=SCRATCH and restore each
tape
one by one but this takes forever. I did get enough tapes back to scratch
to be able to work
but need a faster method.
I am not familiar with writing scripts as of now. I am currently learning
to be able to automate
a few things.
Thanks,
Alan Wells
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
