All,

I am looking for a select statement that will enable me to determine the
total amount of
data backed up (disk and tape).  I know I can use 'select * from stgpools'
and see 1) est_capacity_mb and 2) the pct_utilized.  Is there an SQL
function where I can do the math and get the 1) capacity used for each
stgpool and 2) capacity used for all stgpools.



--
Joshua S. Bassi
Joshua S. Bassi
Independent IT Consultant
IBM Certified - AIX/HACMP, SAN, Shark
Tivoli Certified Consultant- ADSM/TSM
Cell (408)&(831) 332-4006
jbassi AT ihwy DOT com