It will take quite a while to run, but here is what I put
together...probably not a very efficient query, and I haven't tested it
with using all stgpools, but you could always do a single query for each
stgpool....Oh yeah, and it is based off of EST_CAP, and PCT_UTIL, so it
is no real representation by a long shot.

select stgpools.stgpool_name, sum(cast((volumes.EST_CAPACITY_MB) *
(volumes.PCT_UTILIZED) / (100) as INT)) / 1024 as "Used_GB",
sum(cast((volumes.EST_CAPACITY_MB) * (volumes.PCT_UTILIZED) / (100) *
(volumes.PCT_RECLAIM) / (100) as INT)) / 1024 as "RECLAIMABLE_GB" from
volumes,stgpools where volumes.stgpool_name = stgpools.stgpool_name
group by stgpools.stgpool_name 

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Bell, Charles (Chip)
Sent: Wednesday, June 06, 2007 3:22 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] SQL select for primary stgpool data amount

Does anyone have a handy SQL select statement or query that will give
you a one-line picture of how much total data you have sitting on all
primary storage pools in that moment of time? Thanks in advance! I kinda
need this in a hurry...

 

God bless you!!! 

Chip Bell
Network Engineer I
IBM Tivoli Certified Deployment Professional Baptist Health System
Birmingham, AL 



 



-----------------------------------------
Confidentiality Notice:
The information contained in this email message is privileged and
confidential information and intended only for the use of the individual
or entity named in the address. If you are not the intended recipient,
you are hereby notified that any dissemination, distribution, or copying
of this information is strictly prohibited. If you received this
information in error, please notify the sender and delete this
information from your computer and retain no copies of any of this
information.