I just have it as a script:

DEFINE SCRIPT  PP3583 "set sqldisplaymode wide"
UPDATE SCRIPT  PP3583 "select 'upd libv 3583lib ' || volume_name || ' stat=scr' 
from libvolumes where library_name='3583LIB' and
status='Private' and last_use is NULL and owner='TSM_LIBMGR'"

And it generates a list of UPD LIBV commands. I then just cut/paste it back 
into the dsmadmc on the library manager. If the tape
isn't a scratch, then the update will fail. I always run an AUDIT LIBR on the 
library clients first.

tsm: TSM_LIBMGR>run pp3583

Unnamed[1]: upd libv 3583lib 000604 stat=scr

ANR1462I RUN: Command script PP3583 completed successfully.

Not really automated at this point, but it works.


Bill Boyer
"Some days you're the bug, some days you're the windshield" - ??

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of 
Allen S. Rout
Sent: Friday, January 06, 2006 5:26 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Running tapes off-site multiple times in a day?

>> On Fri, 6 Jan 2006 16:39:29 -0500, "Kauffman, Tom" <KauffmanT AT NIBCO DOT 
>> COM> said:


> The interaction forced me to think through the actuall issues and work
> out what *looks* like a viable way to handle the process. With a bit
> of luck, I will be in a position to try my ideas out in early
> February, and I'll report back as to whether things have worked out.


Buy us plane tickets, and we'll all come and second-guess you.
Watching all the advice (including mine) , I was reminded of a Dilbert in which 
PHB is telling him which way to move the mouse. :)


- Allen S. Rout
- No, no! LEFT!