|
Re: Question - How can Icount files and MB currently under ADSM/T SM?
2000-02-22 17:37:03
|
Subject: |
Re: Question - How can Icount files and MB currently under ADSM/T SM? |
|
From: |
Russell Street <russells AT AUCKLAND.AC DOT NZ> |
|
Date: |
Wed, 23 Feb 2000 11:37:03 +1300 |
> Thanks for the reply. I suspect my results because of the low
> values returned.
The figure is in mega bytes, so if the select comes back with '34'
then you are in trouble ;)
There are other ways to count up the numbers:
query stgpool or "select sum(EST_CAPACITY_MB*PCT_UTILIZED/100) from stgpools"
query volume or "select sum(EST_CAPACITY_MB*PCT_UTILIZED/100) from volumes"
All three selects (the third is of the occupancy table) all produce
the same number for me (11TB).
Russell
|
|
|
