This is probably the best you can do:

        select domain_name, sum(occ.backup_mb)/1024 as BACKUP_GB,
sum(occ.archive_mb)/1024 -
        as ARCHIVE_GB from nodes n, auditocc occ where
n.node_name=occ.node_name  group by domain_name 


TSM isn't good at telling you "space used", because most people have
tape drives that compress the data.
What TSM records in occupancy and auditoccupancy is the amount of data
that comes in to it from the client.

If a client is doing compression, TSM records the amount it receives,
which is less than if the client didn't compress the data first.

If the clients don't do compression, TSM records that it receives larger
amounts of data.  Then it sends the data out to tape and the tape drive
compresses the data anyway, so the amount TSM tells you the client is
using is a lot less than the amount of media you need.

If you have a mixture of clients compressing and not compressing, it's
real hard to get any numbers that are useful, except your RELATIVE
numbers from one month to the next are useful; at least you can tell
which domain/client is growing the fastest!

  
Wanda Prather
"I/O, I/O, It's all about I/O"  -(me)



-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Pretorius Louw <louw AT sun.ac DOT za>
Sent: Friday, July 15, 2005 5:30 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Select to see total Size by Policy Domain
Importance: High


Is there a way of seeing total space used by Policy Domain?
 
Okay I know there's a way cause its TSM, but alas i do not know it.
 
Regards

Louw Pretorius

_______________________________

Informasie Tegnologie

Stellenbosch Universiteit

 

There is only 10 kinds of people in the world: Those who understand
binary and those who don't