Boy, wouldn't that be nice!

The problem is that PREVIEW=YES is not an option that's available to
the ADSM client.  It's only available for certain ADSM server operations.

Sigh.

The worst of it is, it's really no business of the client which volumes
have the data.  That's the server's issue.

If you trust SELECT, you could issue the following rather arcane query:

        select distinct node_name,volumes.volume_name,status,pct_utilized -
                from volumeusage,volumes where node_name in -
                        ( select distinct node_name from volumeusage -
                          where volume_name=upper('$1') ) -

                and volumeusage.volume_name=volumes.volume_name -
                order by volume_name

However, if you are restoring only a filespace, then you'll have to throw
something in about volumeusage.filespace='/file/space/name' and it really
won't go below that for a directory subtree.

Rich

At 07:41 PM 5/19/99 -0500, you wrote:
>Not sure about Linux but you should be able to do a restore with the
>PREVIEW=YES option. This will not do an actual restore, but it should
>tell you what volumes you need.
>
>> -----Original Message-----
>> From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf 
>> Of
>> Red Hat Linux User 1
>> Sent: Tuesday, May 18, 1999 2:50 PM
>> To: ADSM-L AT VM.MARIST DOT EDU
>> Subject: Re: How to get a list of tapes needed for a restore via SAP R3
>>
>>
>> No way to know what exact vol numbers will be, but you sure know
>> the range. You can query the volumes in the primary tape pool to
>> get the list of volumes in the stg pool.
>>
>>
>>                            -Qun Du
>>
>>                                  Kent State University, U.S.A
>>
>
>

Richard C. Dempsey                 email: dempsey AT kodak DOT com
Public Online Services             pager: 716-975-3539
11th Floor, Bldg 83, RL            phone: 716-477-3457
Eastman Kodak Company              fax:   716-722-3885
Rochester, NY 14650-2203