Hello,
it will work if we have a maxscr higher or equal to the number of nodes, but
if not, the objects on the tape will be different from the first, very
probably !!

thanks anyway,

rene

-----Original Message-----
From: Jolliff, Dale [mailto:xjolliff AT TI DOT COM]
Sent: Friday,5. September 2003 15:25
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Which nodes on a given tape, what maxscr value to use ?


How about just a "q con {volume ID} count=1"
That will work on collocated volumes and much quicker than the select.


-----Original Message-----
From: David E Ehresman [mailto:deehre01 AT LOUISVILLE DOT EDU] 
Sent: Friday, September 05, 2003 8:17 AM
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.