We do collocate at the filespace level and we have a Shell script that bumps
up the maxscratch values to the number of tapes we want to be able to
recover from. To save tape mounts we base the number on the number of drives
and Recovery System Drives). We do have to run this script periodically
throughout the day to make sure there are enough scratch tapes and to make
sure that there are not too many. 

i.e. Just after morning Offsite process bump it up by 1 
        (Makes sure that there is at least 1)

        Later in the afternoon bump it up again to the desired number.

Bill Slaughter
Tupperware
407-826-4580


-----Original Message-----
From: Lambelet,Rene,VEVEY,GL-CSC [mailto:Rene.Lambelet AT NESTLE DOT COM] 
Sent: Friday, September 05, 2003 9:32 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Which nodes on a given tape, what maxscr value to use ?

David, thanks a lot for your answer to my first question...

rene

-----Original Message-----
From: David E Ehresman [mailto:deehre01 AT LOUISVILLE DOT EDU]
Sent: Friday,5. September 2003 15:17
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Which nodes on a given tape, what maxscr value to use ?


Replace $1 with the volume name and this LONG RUNNING query will tell you
what nodes are on a tape:

select distinct node_name from volumeusage where volume_name='$1'

>>> Rene.Lambelet AT NESTLE DOT COM 9/5/2003 9:11:44 AM >>>
Hi,
as many of us probably, we use seq. stg pools with collocation ON for
backups. To limit the number of tapes used, maxscr value is smaller than the
number of nodes.

- Now, any advice to write an sql select to list all node_names stored on a
given volume (distinct node_name) ?

- What I would also appreciate is a method to know when to increase the
maxscr value to limit the number of volumes / node to an acceptable level
(not too many tapes to mount for restoring).

Thanks for any tips,

yours,

                René LAMBELET
                NESTEC  SA
                GLOBE - Global Business Excellence
                Central Support Center
                SD/ESN
                Av. Nestlé 55  CH-1800 Vevey (Switzerland) 
                tél +41 (0)21 924 35 43   fax +41 (0)21 924 13 69   local
K4-104
                mailto:rene.lambelet AT nestle DOT com 

                This message is intended only for the use of the addressee
                and may contain information that is privileged and
confidential.