Re: Script to CHECKOUT multiples tapes on SCSI library

2001-12-11 Thread Braich, Raminder

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-
> From: Etienne Brodeur [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, December 10, 2001 3:31 PM
> To:   [EMAIL PROTECTED]
> 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
>  DA.COM>  cc:
> Sent by: Subject: Re: Script to
> CHECKOUT multiples tapes on SCSI library
> "ADSM: Dist
> Stor Manager"
> <[EMAIL PROTECTED]
> 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
>  .CO.UK>  cc:
> Sent by: Subject: Re: Script to
> CHECKOUT multiples tapes on SCSI library
> "ADSM: Dist
> Stor Manager"
> <[EMAIL PROTECTED]
> 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 <[EMAIL PROTECTED]>@VM.MARIST.EDU> on 07/12/2001 14:13:59
>
> Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
>
> Sent by:  "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
>
> To:   [EMAIL PROTECTED]
> 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
>

Re: Script to CHECKOUT multiples tapes on SCSI library

2001-12-10 Thread Tab Trepagnier

Etienne,

What we do is this:

MOVE MEDIA * STG=COPYPOOL WHERESTATUS=FULL,FILL CHECKL=NO REMOVE=YES

That ejects all the copypool tapes from the library but doesn't affect any
other storage pools defined on the same library.  Semi-weekly, we eject
full and filling tapes (since files can "span" tapes) and send to our vault
vendor.  We don't check labels because our library hasn't made any mistakes
and an administrator is there to verify the tape ID upon removal.  That
speeds things up significantly.

Then we do an ordinary CHECKOUT of the latest DB backup tape, which is
created after all copypool data is written.
CHECKOUT LIBV DLTLIB volume_name CHECKL=NO REMOVE=YES

So that DB backup has an up-to-date snapshot of the contents of ALL
copypool tapes.

Then we create a floppy disk holding the updated volume history file and
various other system configuration files.

We send the copypool tapes, the DB backup tape, and the config floppy to
the vault as one package.

Good luck.

Tab Trepagnier
TSM Administrator
Laitram Corporation






Etienne Brodeur <[EMAIL PROTECTED]>@VM.MARIST.EDU> on 12/10/2001 02:40:16
PM

Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>

Sent by:  "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>


To:   [EMAIL PROTECTED]
cc:
Subject:  Re: Script to CHECKOUT multiples tapes on SCSI library


But If I do what you suggest it would also checkout the tapes for my onsite
copies that are full right?  I am looking for a way to check out multiples
tapes with one command (running a script would be my guess) to take a list
of predetermined tapes out of a LTO 3583.  I want to be able to check out
the OFFSITE tapes that are full and filling and the daily DB backup that is
in the OFF devclass.

Is ther a script that will allow me to identify them and then create a
macro file that could be run from to check them out one by one with
REMOVE=BULK?\

If anyone has this would you mind sharing?

Thanks for your help,

Etienne Brodeur



Martin Trcka
 cc:
    Sent by:     Subject: Re: Script to
CHECKOUT multiples tapes on SCSI library
"ADSM: Dist
Stor Manager"
<[EMAIL PROTECTED]
RIST.EDU>


2001-12-10
08:07 AM
Please
respond to
"ADSM: Dist
Stor Manager"






>  Is the MOVE MEDIA a command I could use to do this?
Yes.
Issue "MOVE MEDIA * STG=*  wherestatus=full", f.e. This will check all full
tapes from your library out.

Martin Trcka



Re: Script to CHECKOUT multiples tapes on SCSI library

2001-12-10 Thread Taylor, David

Frequent submitter, and all-around great guy, Mark Stapleton helped with
this. (though he DOES still owe me a mug!)

We do this from within an AIX Korn-shell script.  This is basics of the
logic:

---
#  get a list of copypool tapes that are NOT offsite
dsmadmc -id admin -pass=$TSMPWD "select volume_name from volumes where
stgpool_name-='COPYPOOL' and access <>'OFFSITE' "| sed '1,2d | grep -c "^
*$" | grep -v AND[0-9] > $CHECKOUTLIST

#  get a list of the DBB tapes
dsmadmc -id=admin -pass=$TSMPWD "select volume_name from volhistory where
type='BACKUPFULL'" | sed '1,2d' | grep -v "^ *$" | grep -v ANS[0-9] >
$TMPDBLIST

# compare the backup tapes to that currently known to be offsite
# to find the onsite DBB
cat $PHYSICALVAULTLIST | while read VOL_LABEL; do
   VAL=$VAL$VOL_LABEL\|
done
VAL=$VAL"garbage"
egrep -v $VAL $TMPDBLIST >> $CHECKOUTLIST

# change the status of the ones to be checked out and ccheck 'em out
cat $CHECKOUTLIST | while read VOL_LABEL; do
dsmadmc -id=admin -pass=$TSMPWD "upd vol $VOL_LABEL access=offsite" >
$CHECKOUTLOG 2> &1
dsmadmc -id=admin -pass=$TSMPWD "checkout libv  $VOL_LABEL
checklabel=no remove=bulk" >> $CHECKOUTLOG 2>&1
done
----




-Original Message-----
From: Etienne Brodeur [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 10, 2001 2:40 PM
To: [EMAIL PROTECTED]
Subject: Re: Script to CHECKOUT multiples tapes on SCSI library


But If I do what you suggest it would also checkout the tapes for my onsite
copies that are full right?  I am looking for a way to check out multiples
tapes with one command (running a script would be my guess) to take a list
of predetermined tapes out of a LTO 3583.  I want to be able to check out
the OFFSITE tapes that are full and filling and the daily DB backup that is
in the OFF devclass.

Is ther a script that will allow me to identify them and then create a
macro file that could be run from to check them out one by one with
REMOVE=BULK?\

If anyone has this would you mind sharing?

Thanks for your help,

Etienne Brodeur



        Martin Trcka
 cc:
Sent by: Subject: Re: Script to CHECKOUT
multiples tapes on SCSI library
"ADSM: Dist
Stor Manager"
<[EMAIL PROTECTED]
RIST.EDU>


2001-12-10
08:07 AM
Please
respond to
"ADSM: Dist
Stor Manager"






>  Is the MOVE MEDIA a command I could use to do this?
Yes.
Issue "MOVE MEDIA * STG=*  wherestatus=full", f.e. This will check all full
tapes from your library out.

Martin Trcka


**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

www.mimesweeper.com
**



Re: Script to CHECKOUT multiples tapes on SCSI library

2001-12-10 Thread Etienne Brodeur

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
  cc:
Sent by: Subject: Re: Script to CHECKOUT multiples 
tapes on SCSI library
"ADSM: Dist
Stor Manager"
<[EMAIL PROTECTED]
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
  cc:
        Sent by:         Subject:     Re: Script to
CHECKOUT multiples tapes on SCSI library
"ADSM: Dist
Stor Manager"
<[EMAIL PROTECTED]
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 <[EMAIL PROTECTED]>@VM.MARIST.EDU> on 07/12/2001 14:13:59

Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>

Sent by:  "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>

To:   [EMAIL PROTECTED]
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
             cc:
Sent by: Subject: Re: Script to
CHECKOUT multiples tapes on SCSI library
"ADSM: Dist
Stor Manager"
<[EMAIL PROTECTED]
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:[EMAIL PROTECTED]]On
> Behalf Of Etienne Brodeur
> Sent: Thursday, December 06, 2001 9:09 PM
> To: [EMAIL PROTECTED]
> 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



Re: Script to CHECKOUT multiples tapes on SCSI library

2001-12-10 Thread Etienne Brodeur

But If I do what you suggest it would also checkout the tapes for my onsite
copies that are full right?  I am looking for a way to check out multiples
tapes with one command (running a script would be my guess) to take a list
of predetermined tapes out of a LTO 3583.  I want to be able to check out
the OFFSITE tapes that are full and filling and the daily DB backup that is
in the OFF devclass.

Is ther a script that will allow me to identify them and then create a
macro file that could be run from to check them out one by one with
REMOVE=BULK?\

If anyone has this would you mind sharing?

Thanks for your help,

Etienne Brodeur



Martin Trcka
 cc:
Sent by: Subject: Re: Script to CHECKOUT multiples 
tapes on SCSI library
"ADSM: Dist
Stor Manager"
<[EMAIL PROTECTED]
RIST.EDU>


2001-12-10
08:07 AM
Please
respond to
"ADSM: Dist
Stor Manager"






>  Is the MOVE MEDIA a command I could use to do this?
Yes.
Issue "MOVE MEDIA * STG=*  wherestatus=full", f.e. This will check all full
tapes from your library out.

Martin Trcka



Re: Script to CHECKOUT multiples tapes on SCSI library

2001-12-10 Thread Martin Trcka

>  Is the MOVE MEDIA a command I could use to do this?
Yes.
Issue "MOVE MEDIA * STG=*  wherestatus=full", f.e. This will check all full
tapes from your library out.

Martin Trcka



Re: Script to CHECKOUT multiples tapes on SCSI library

2001-12-07 Thread Ken Long

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
  cc:
Sent by:     Subject: Re: Script to CHECKOUT multiples 
tapes on SCSI library
"ADSM: Dist
Stor Manager"
<[EMAIL PROTECTED]
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 <[EMAIL PROTECTED]>@VM.MARIST.EDU> on 07/12/2001 14:13:59

Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>

Sent by:  "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>


To:   [EMAIL PROTECTED]
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
         cc:
        Sent by: Subject: Re: Script to
CHECKOUT multiples tapes on SCSI library
"ADSM: Dist
Stor Manager"
<[EMAIL PROTECTED]
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:[EMAIL PROTECTED]]On
> Behalf Of Etienne Brodeur
> Sent: Thursday, December 06, 2001 9:09 PM
> To: [EMAIL PROTECTED]
> 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



Re: Script to CHECKOUT multiples tapes on SCSI library

2001-12-07 Thread Farren Minns

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 <[EMAIL PROTECTED]>@VM.MARIST.EDU> on 07/12/2001 14:13:59

Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>

Sent by:  "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>


To:   [EMAIL PROTECTED]
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
 cc:
    Sent by:     Subject:     Re: Script to
CHECKOUT multiples tapes on SCSI library
"ADSM: Dist
Stor Manager"
<[EMAIL PROTECTED]
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:[EMAIL PROTECTED]]On
> Behalf Of Etienne Brodeur
> Sent: Thursday, December 06, 2001 9:09 PM
> To: [EMAIL PROTECTED]
> 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



Re: Script to CHECKOUT multiples tapes on SCSI library

2001-12-07 Thread Martin Trcka

Doesn't MOVE MEDIA command meet your needs ?

Martin Trcka

> -Original Message-
> From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On
> Behalf Of Etienne Brodeur
> Sent: Thursday, December 06, 2001 9:09 PM
> To: [EMAIL PROTECTED]
> 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



Re: Script to CHECKOUT multiples tapes on SCSI library

2001-12-07 Thread Etienne Brodeur

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
 cc:
Sent by: Subject: Re: Script to CHECKOUT multiples 
tapes on SCSI library
"ADSM: Dist
Stor Manager"
<[EMAIL PROTECTED]
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:[EMAIL PROTECTED]]On
> Behalf Of Etienne Brodeur
> Sent: Thursday, December 06, 2001 9:09 PM
> To: [EMAIL PROTECTED]
> 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



Re: Script to CHECKOUT multiples tapes on SCSI library

2001-12-06 Thread Prather, Wanda

Try REMOVE=BULK?

-Original Message-
From: Etienne Brodeur [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 06, 2001 3:09 PM
To: [EMAIL PROTECTED]
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



Script to CHECKOUT multiples tapes on SCSI library

2001-12-06 Thread Etienne Brodeur

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