how to calculate the total amount of data on the storage pools TSM

Hi,

this one will tell you the total amount in GB of your pools, and an estimate on both average occupation of each tape and maximum:

SELECT stgpool_name AS "Storage Pool ", CAST(COUNT(*) as DECIMAL(6,0)) AS "Volumes", CAST(SUM(est_capacity_mb/1024/100*pct_utilized) AS DECIMAL(8,3)) AS "GB in Pool", CAST(AVG(est_capacity_mb/1024/100*pct_utilized) AS DECIMAL(7,3)) AS "Average/Tape", CAST(MAX(est_capacity_mb/1024) AS DECIMAL(7,3)) AS "Max/Tape" FROM VOLUMES WHERE status NOT IN ('PENDING', 'EMPTY') GROUP BY stgpool_name ORDER BY 3 desc

hope this helps
max

max,
          i got two tsm environment, same version but differrent sizes. in the small one the command worked perfect but in the big one i got the following warning:

ANR0162W Supplemental database diagnostic information: -1: 22003: -413 ([IBM] [CLI Driver] [DB2 / NT64] SQL0413N An overflow occurred during numeric data type conversion.
  ) .STATE = 22003

looks like the amount of data to process is too big. am i right?

please can you help me with this?

thanks in advance!!!!

max thanks both qerys worked  just perfect!!!!