Mark,

  From what I can tell from your note you have 4 volumes 2 on-site and 2
off-site. So you actually have 12gb of data on 4 volumes. This could be true
depending on compression and the microcode that your 3490E's are at. Don't
forget that ADSM will report on all data for a node on a server. It doesn't
discriminate between on-site and off-site.







"Mark Brown (CC Operations Supervisor)" <CCMB AT MUSICA.MCGILL DOT CA> on 
05/11/99
04:00:57 PM

Please respond to "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>


To:   ADSM-L AT VM.MARIST DOT EDU
cc:    (bcc: BRIAN NICK/Phoenix Home Life Mutual Insurance)
bcc:  BRIAN NICK/Phoenix Home Life Mutual Insurance
Subject:  SELECT. How to list all tapes for a node.




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