We run the following macro to checkout our tapes. Pipe the output of this
macro to another file. The output would be in this format 'checkout libv
3494 volume_name remove=yes'. Execute this output file.Once the tapes are
all out mark the volumes as offsite. Do this by "update volume volume_name
access=offsite".

select 'checkout libv 3494 '|| volume_name ||' remove=yes' as "Remove Tape
Script                      " from volumes where not access='OFFSITE' and
stgpool_name='COPYPOOL' and days(current_date)-days(last_write_date)<=1
select volume_name, date_time as "DATE_TIME                 "from volhistory
where type='BACKUPFULL'
select 'checkout libv 3494 '|| volume_name ||' remove=yes' as "Remove DB
Tape Script                    " from libvolumes where last_use='DbBackup'

-Raminder Braich
> -----Original Message-----
> -----Original Message-----
> From: Etienne Brodeur [SMTP:ebrodeur AT SERTI DOT COM]
> Sent: Monday, December 10, 2001 3:31 PM
> To:   ADSM-L AT VM.MARIST DOT EDU
> Subject:      Re: Script to CHECKOUT multiples tapes on SCSI library
>
> That is a very good question, sinbce I don't have DRM (or at least I
> didn't
> buy it so I am not using it).  Could you give me an exemple of how your
> script pulls a list a tapes to be checked out?  I am new to TSM and
> finding
> that doint it manually takes forever if I have multiples tapes to take out
> (which I always do).
>
> Thanks
>
> Etienne Brodeur
>
>
>
>                     Ken Long
>                     <ken.long@WHE        To:     ADSM-L AT VM.MARIST DOT EDU
>                     DA.COM>              cc:
>                     Sent by:             Subject:     Re: Script to
> CHECKOUT multiples tapes on SCSI library
>                     "ADSM: Dist
>                     Stor Manager"
>                     <ADSM-L AT VM DOT MA
>                     RIST.EDU>
>
>
>                     2001-12-07
>                     10:30 AM
>                     Please
>                     respond to
>                     "ADSM: Dist
>                     Stor Manager"
>
>
>
>
>
>
> How many of the various DR commands are usable if we haven't purchased the
> separate DRM module?  Back in the ADSM v2 days, in lieu of purchasing DRM,
> we developed AIX shell scripts which manage the checkout process.  Since
> then, I've ignored the DR commands as I thought they weren't available for
> my use because I didn't purchase DRM.
>
> Our current setup uses TSM server scripts to build a list of volumes to be
> checked out, then uses an AIX script to convert the list into a macro to
> execute the checkout commands.
>
>
>
>
>                     Farren Minns
>                     <fminns@WILEY        To:     ADSM-L AT VM.MARIST DOT EDU
>                     .CO.UK>              cc:
>                     Sent by:             Subject:     Re: Script to
> CHECKOUT multiples tapes on SCSI library
>                     "ADSM: Dist
>                     Stor Manager"
>                     <ADSM-L AT VM DOT MA
>                     RIST.EDU>
>
>
>                     12/07/2001
>                     09:14 AM
>                     Please
>                     respond to
>                     "ADSM: Dist
>                     Stor Manager"
>
>
>
>
>
>
> I use the command
>
> move drm * wherestate=mountable tostate=vault remove=bulk
>
> That should be the kind of thing you are after.
>
> Thanks
>
> Farren Minns
>
>
>
>
>
>
> Etienne Brodeur <ebrodeur AT SERTI DOT COM>@VM.MARIST.EDU> on 07/12/2001 
> 14:13:59
>
> Please respond to "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
>
> Sent by:  "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
>
> To:   ADSM-L AT VM.MARIST DOT EDU
> cc:
> Subject:  Re: Script to CHECKOUT multiples tapes on SCSI library
>
>
> Thanks for the help,
>
>      From I have been reading the MOVE MEDIA command is to allow you to
> move onsite tapes to an overflow location.  What I want to be able to do
> is
> to identify which tapes I need to send offsite and with one command check
> them out, instead of having to check the tapes out one at a time, ie one
> command per tape I want to checkout.  Right now if I have 8 tapes to
> checkout to the offsite vault I need to execute 8 commands.  I would like
> to be bale to use one command to do this such as specifying a list which
> is
> why I was trying to use the VOLFILE option.  Is the MOVE MEDIA a command I
> could use to do this?
>
> Thanks again for the suggestion.
>
> Etienne Brodeur
>
>
>
>
>                     Martin Trcka
>                     <mtrcka@SMPAS        To:     ADSM-L AT VM.MARIST DOT EDU
>                     .CZ>                 cc:
>                     Sent by:             Subject:     Re: Script to
> CHECKOUT multiples tapes on SCSI library
>                     "ADSM: Dist
>                     Stor Manager"
>                     <ADSM-L AT VM DOT MA
>                     RIST.EDU>
>
>
>                     2001-12-07
>                     08:29 AM
>                     Please
>                     respond to
>                     "ADSM: Dist
>                     Stor Manager"
>
>
>
>
>
>
> Doesn't MOVE MEDIA command meet your needs ?
>
> Martin Trcka
>
> > -----Original Message-----
> > From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On
> > Behalf Of Etienne Brodeur
> > Sent: Thursday, December 06, 2001 9:09 PM
> > To: ADSM-L AT VM.MARIST DOT EDU
> > Subject: Script to CHECKOUT multiples tapes on SCSI library
> >
> >
> > I have an LTO3583 connected to a Windows2000 TSM server 4.2.0
> >
> > Is there a way with a script or the DSMADMC to check out multiples tapes
> > with one command?
> >
> > When I try the VOLLIST or VOLFILE options the sever tells me I can't use
> > this option with a SCSI library.  Is there a similar options for a non
> > SCISI LIB?  By writing a server scripts or something?
> >
> > Any help would be greatly appreciated.
> >
> > Etienne Brodeur