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:[EMAIL PROTECTED] On Behalf Of Allen S. Rout Sent: Friday, January 06, 2006 5:26 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: Running tapes off-site multiple times in a day? >> On Fri, 6 Jan 2006 16:39:29 -0500, "Kauffman, Tom" <[EMAIL PROTECTED]> 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!