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:[EMAIL PROTECTED] Sent: Friday, September 05, 2003 8:17 AM To: [EMAIL PROTECTED] 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' >>> [EMAIL PROTECTED] 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:[EMAIL PROTECTED] This message is intended only for the use of the addressee and may contain information that is privileged and confidential.
