Sorry, I just realized the SQL query I gave you will wrap the output at an
inconvenient spot.
This one works OK (the blanks are intentional":
adsm> select 'update libv LB10.0.0.7' as " ",
volume_name, ' status=scratch' from libvolumes where status='Scratch' and
library_name='LB10.0.0.7' > d:\status.txt
-----Original Message-----
From: Prather, Wanda [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 21, 2001 3: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]>
