Re: SELECT. How to list all tapes for a node.
1999-05-12 02:40:41
Hi Mark,
If the Client does not compress his data, IDRC will do it for you.
Be happy to get such an compression-rate.
The ADSM-Server display not the compressed but the original size of
data, thats why you get 12 GB data on 4 3490E.
"Mark Brown (CC Operations Supervisor)" wrote:
>
> Hello,
>
> Awhile ago I posted a similar message on how to use the SELECT sql
> command to list ALL tapes for a NODE. I did get some responses and
> I appreciate the responses I got. Like this example:
>
> select volume_name from volumeusage where node_name='XXXXXX'
>
> Now this command does come back with some volume names. For node XXXXXX
> it came back telling me that there were 4 volumes. 2 tapes here onsite
> and 2 tapes at an OFFSITE location.
>
> MY PROBLEM here is that node XXXXXX has 12gigs of data on the server!!
> The server is running on an OS/390 platform using 3490E tapes to
> store data. How do I get 12 gigs of data onto 2 tapes!!!
>
> Thanks for any help.
>
> Thank You,
> Mark Brown, Operations Supervisor
> McGill University, Computing Centre
> Phone (514) 398-2321
> E-Mail --> ccmb AT musica.mcgill DOT ca
> Home Page --> http://mbrown.cc.mcgill.ca
--
_________________________________________________
_________________________________________________
Kind Regards
Andreas Buser
Tel: ++41 61 285 73 21 Fax: ++41 61 285 70 98
Email: Andreas.Buser AT Basler DOT ch
Address:
Basler Versicherungsgesellschaft
Andreas Buser
Abt. Informatik
Aeschengraben 21
4002 Basel
Switzerland
|
|
|